I think one of the issues with space exploration for people is that it just feels so pointless and intangible - its perception so locked into the realms of sci fi that the act of trying feels more of an indulgent nod to starship fantasies and "space race" dick-waving than to realistic scientific progress.
[0] money the "whatabout" brigade say should go to cancer research, which too, is also an investment with unsure outcomes (and which usually helpfully ignore things like CERN's impact on cancer research with second order applications of other discoveries...)
It is now more than 20 years since the top quark was discovered, has society profited enought from knowing the mass of the top quark that the Tevatron is paid off?
Or is this way of thinking of science funding just destructive?
It's the same argument as to why we shouldn't invest in infrastructure "don't build those high speed train routes, we'll only see the benefit in 30 years" - space exploration is an investment in the future, and like a lot of investments, the potential payoff is variable but we can never know without trying.
If we take a VC analogy (being here on HN and all), then you might as well utilise some of your fund on a literal moonshot - if it fails, you scrub it off, take the learnings (and employ, I suspect, a tonne of people in jobs trying to make it happen). If it wins, you get your outsized outcome to 10x.
Sometimes we need state actors to make big bets - like investing in CERN (which has given us the WWW, the LHC, etc...).