(I think that (most of) space exploration should be left completely to the private sector, not just the execution, but also the financing.
Even if you think that the government should be involved in the sciences, manned space flight is pretty much a more expensive version of unmanned space flight.
It's useful as entertainment only, so far. Eg the moon landing was great entertainment, better than a Marvel movie. But also more expensive. I don't think the government should be involved in providing entertainment.
But in any case, after the moon landing, the amount of inspiration coming out of manned space flight has dropped dramatically.)