Just a point of order:
The US human space programme is not 'dead', by any definition of the word. The way I see it, there are effectively two 'parts' of it now, rather than just one. Firstly, there's the more-or-less new commercial side - for example SpaceX, and SpaceDev (just to name two -
here's a bigger list). There's been a lot of talk about this, but so far it seems to be going well, IMO. Secondly, you have what NASA's doing: there's the ever-present ISS - which is just casually lurking around 200 miles above the planet at about 17,000 mph at the moment - and then there are their rockets, which quite frankly confuse the hell out of me, since I haven't been following what's happening with them.
At any rate, it does suck that the Space Shuttles are being retired, and NASA itself won't have any new vehicles for a few years, but I'd be extremely surprised if they don't get something else (ok, it won't be as cool as the Shuttle - but it'll probably do whatever it's designed to do very well) in the near future.
The shuttles are being shipped to different places for display. Some of the places really make you scratch your head. Not one was sent to NASA Houston. lol
IMO, I don't think Houston particularly deserved one - just look at what they allowed to happen with their Saturn V (
http://www.collectspace.com/news/news-030104a.html#030104). That is a fairly thin argument to not give them one (and just giving them two seats, IIRC, seems a bit stingy to say the least), but I have to say I can't disagree with any of the other places: Florida - of course, Air and Space Museum - of course, NYC - hard to say, but it is a massive tourist attraction, so it does make sense to have one there*, and LA - they were built nearby and it is sensible to have one on the West Coast.
*However, they are relocating Concorde to make room for it, which is a big no-no in my books. Nothing moves out of the way for Concorde.