It is hard to try and analyse what goes through their minds without putting a human spin on it. I am sure that many horses are a little frightened when they first go to a racecourse, hence why you often hear two year olds hollering in the paddock pre-race: they are calling out to their friends for reassurance. It is also why you hear many jockeys talk about trying to give an unraced two year old an easy introduction. If the horse is very green there is no point in the jockey flogging it half to death trying to win, all that will happen is the horse will learn to associate being at the racecourse with a bad experience and will continue to be nervous and green at future outings.
In Frankel's case, I get the impression he believes himself to be ruler of the roost. So we are told, they tried to move him from his existing stable at Warren Place, which overlooks the yard and the ramp for the horse box, but he was having none of it - he is intelligent and inquisative and likes to see everything that is going on. He also reportedly has the largest appetite of any horse in Warren Place (23lbs of oats, plus hay every day, the equivalent of 35,000 calories) and sleeps more than any other horse. The head lass said that, on his return from racing at Newmarket in the Guineas, he was hollering for his dinner within minutes of returning to his stable!
Some horses revel in the attention - Dubai Millennium was another horse who seemed to pose for photos, knowing that he was something special and felt deserving of all the attention he received!
I suspect the clapping and cheering can be unnerving, and I also admit that I was always very concerned about the flags, etc that people were waving around Frankel - some horses will react very badly to that sort of thing. They are flight animals after all - their natural instinct is to run from danger. But Frankel seemed to take it all in his stride.
The process of "letting down" will take a good while. As they say, he will have his workload wound down over the next few weeks at Warren Place, just leaving the yard to walk and trot before being transferred to the stud. There he will be walked in hand everyday to maintain some condition, but allow him to lose his racing fitness. After a while he will be allowed limited turnout in a field (probably in a pen to begin with) and when they are sure he is relaxed enough they will allow him full access to a field of his own. It is very dangerous to turn a race fit Thoroughbred straight out into a field, particuarly as he won't have been out in such open spaces since his yearling days. There is too high a risk he will do something stupid like gallop at full speed and slip over, or try to jump out of the field.
The difference in colts once they have gone to stud can be incredible sometimes, their physique can totally change. Look at New Approach as a racehorse:
You must log in or register to see images
And look at him now as a stallion, just a few years later:
You must log in or register to see images