And, unfortunately, it's all too common on HN that we can't have a discussion about value that doesn't involve a concrete measurement of actual dollars, and since I am not one of the three wealthiest people on the planet, I cannot quote any kind of significant figure for what I personally would be willing to pay to leave the planet in a permanent way.
But, I will say that historically, the populist argument against exploration has always been that it wasn't worth the cost, and that that argument has almost always turned out to be wrong. The technological improvements required to accomplish the exploration have always further benefited human technological development, to say nothing of inspiring later generations to continue pushing boundaries, or of showing us just how possible it is to break through certain boundaries, or of discovering unimagined treasures along the way.
I am steadfastly amongst those few remaining people who thinks that real space exploration is not only worth it, but is essential to our species.
Clearly, sending a man to the moon captured the imagination of a certain generation, a generation that is growing older. But it didn't capture my imagination particularly strongly; it was before my time, and now it seems to me like an massive achievement in the same way as the pyramids were massive achievements. Literally massive, in that the scale is impressive, but monuments essentially without purpose other than aggrandizing those who achieved them.
So I don't see them as a big thing that was done in the past that is lacking in the present. I don't see a need for them. You might as well ask why we haven't built a bigger pyramid than at Giza.