Can you step back and look at the big picture?
1) Going to the moon has what tangible short _or_ long term benefit to human kind that you can articulate now?
I'd argue you can't really. The science learned will be invaluable to certain fields, but right now it's a gamble at best. Yes, something good will come of it, granted, but what and when? Noone knows. I'm not saying it's not worth it, I'm suggesting there are more tangible things that can be done with money, now.
2) "Spreading the wealth around" is exactly what we need to do.
Bill Gates is doing a good thing for humanity and helping out in fields such as medicine (malaria), he even donates money to PBS, etc for education among other things. Can you say the same for the other billionaires on the planet? Probably not.
Look, the truth of the matter is, we have enough problems here at home (both in the US and in the world) that need to be addressed and fixed before we spend billions upon billions of dollars on building things on other planets.
Healthcare in the US is an absolute mess. I have friends that are downright uninsureable. One, due to cancer while he wasn't covered, he's absolutely boned. Noone will touch him with a stick let alone their money.
If that means my taxes go up 5%, so be it. If something happens to me, my wife, kids, parents, etc, I want to know they will be taken care of and not just looked at in terms of profitability.
Capitalism works to a certain extent. Human health is _not_ one of them.
The short of it is, I'm a science guy and I can see the benefit in taking money from pure science and potentially moving it to the health of our citizens.
I'm pretty well off as I live quite comfortably but I know many who aren't and they should have the same health care as I do. End of story.
* Yes, I took the healthcare "socialist" stance with this post. It is something I believe in and can articulate with personal experience.