god whats with all the 'just move' is that REALLY even remotely possible for most people in the current economic climate?!
seeker i am sorry your son is upset, i too failed the 11+ but i thrived at my secondary modern, got good gcse's and then went to the grammar school for my a levels.
my sister passed, our grades are pretty similar and we both went on to uni and got good degrees, it hasnt made any difference in the long run at all.
i did feel disappointed but i had lots of friends at my school and it worked out fine, plus i didnt envy my sister who had to get up at a god forsaken time to catch the bus to her school whilst i could walk to mine!
as you say it is impossible to shield your child when everyone where you live is expected to take the test and it is looked upon as a failure to not go to the grammar, particulary when a child IS bright etc.
tbh i wouldnt minimse his feelings, he is entitled to them, but i would just praise him, remind him of all he is good at and talk to him positively about the new school whilst letting him know you understand how he feels. in a few months time this will be forgotten hopefully once he is settled at his new school and enjoying it.
i would just try and make the most of the rest of the summer holidays, make some fun memories, they change so much once they go to high school (as you know!) enjoy this time with him and just concentrate on having fun and making him feel positive about himself xxx
we dont have the grammar system here, for which i am grateful tbh.