if going to mars was going to make us better off, I think we wouldn't need public investment
Don't fall for this line of thinking, too often*: public investment is also good for projects that suffer from short-sightedness and for projects that are under-invested due to the Free Rider concerns.
*Not that you are, but it bears mentioning publically.