As someone who barely remembers Apollo 17, I grew up thinking that by the time I was in my 50's (I am 43) we would have a robust space exploration program and would probably have at the very least a colony or science station as a permanent fixture on the moon.
Obviously this isn't going to happen for any number of reasons that range from cost, bad P.R., and the fact that there is not any real reason to be there except as a possible testing ground for a manned mission to Mars.
Personally I think not enough money is spent on space exploration, methods of transportation, etc.
The research that goes into space exploration also benefits earthbound humans as the discoveries generated by that science trickles down to the consumer (think Tang!).
Space is really the future of mankind. While it may not happen any time soon, eventually we are bound to render our planet uninhabitable due to pollution, resource depletion, and over-population.
Than again, I look at what we have accomplished as a species and I think that our extinction may be the best possible thing for the universe.