Im no expert but you say he starts to calm down nearer the end as he is becoming tired. Have you tried to let him burn off some (NOT ALL, as you will need a good bit) of his energy before you go to agility?

i agree with the de-sensitisation. Everyhting is exciting for everyone when iys first apparent but over time becomes a bit dull.