I really don't think the moon is going to be in our long term future nor Mars or any other body in our solar system. Robots and computers, maybe, but not humans. Too hostile of an environment.
We are too fragile for space. We are not meant to travel the stars, as cool as that would be. We should have used that money to undo the damage we've done down here. Maybe explore the oceans even. It was neat, but i'm totally unimpressed by the mission itself. Good will come from it, but I'm not sure it's worth the risk or money while things on Earth are the way they are.