I appreciate what you are saying, Cyrano, but respectfully disagree.
Tell me, what has space science given us that terrestial science hasn't in the last 50 years?
A cure for cancer? Reduction in birth abnormalities? Provision of food-stuffs for the planet? Elimination of disease?
The new frontier of science is biology. This will become more apparent in the next few decades.
I've studied astrophysics, astronomy and all that jazz and at the end of it all I was left thinking it is a fine academic pursuit - similar to trying to calculate pi to a few million decimal places. Suitable for Star Trek idealists and eccentric academics.
A lot of the time people are attracted towards space exploration because they want to see perhaps where we came from and if we are alone. Noble and completely understandable ideals (I share them myself), but only slightly more realistic than a devout belief in the Christian creation story or the Hindu cycle of life and Caste system.
Personally, I don't think we are anywhere near advanced enough to even contemplate space exploration. We can't even feed a huge proportion of our planet and we're trying to set-up a permanent settlement on Mars? It's perverse to the point of absurdity.
I could only see it being worthwhile if, in the endeavour to reach out into our solar system, the US, China, Europe and Russia could be united to achieve it. But I'm not holding my breath. Therefore it will be large multi-nationals that fund space exploration, further bypassing any concept of democracy and centralising power to a select few. It will be a feudal system on a grand scale.
There will be no benefit to 99% of the Earth's population - but at least they can watch people play golf on the surface of Mars to take their mind off their empty stomachs or the catastrophic over-crowding.