sledneck-
It has been 18 years since I was in school for meteorology, so my knowledge is a bit dated. With that said, the three best in the Midwest back then were (in no particular order) Penn State, University of Wisconsin-Madison and Purdue. Penn State seemed to lean more towards preparing someone for the private and/or broadcasting route, while Wisconsin seemed to be more towards the computer end of things and Purdue was more towards research. Of course there is University of Oklahoma for severe weather and Florida State for Tropical.
I think a high school counselor should have a good idea of the best schools for meteorology or at least be able to give you some names and then you can do some research on your own.
My best advice for your son would be to become as good at math/science as he can, because that is what it is all about! If he does not like math and physics, then he might want to rethink his career choice or get ready to bite the bullet and gruel it out for 4 years!
-John