Unfortunately, this is one of those points where the two opposing camps are generally not able to come to any sort of agreement. I grew up reading Cosmos and straining my eyes through a bad telescope and looking up and wanting to be
there instead of
stuck here.
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.