From your comments I feel like you
gotta be familiar with Kim Stanley Robinson's novel SF _Red Mars_ (if not you'd like it), but here's how he tries to make you feel better about your NASA budgetted job, while agreeing with your basic analysis on things like terraforming and many other things you've said (the plot of his earlier novel notwithstanding, he's partially doing penance for it).
> However, even if slower, terraforming Mars remains a great long-term goal; but long-term meaning like ten thousand years. Which means we have to get our relationship to our own planet in order for anything interesting to happen on Mars…
> The main project for civilization now is creating a sustainable way of life here on Earth. That’s the necessary first step; anything beyond would rely on that succeeding, so exploring space is less important now. That said, space science is an earth science. What we learn around the solar system can often illuminate the project we have here of keeping this planet’s biosphere healthy. So I like the space program, and feel it is not funded out of proportion to its importance. Robotic missions are already doing a lot of what we need done, but humans are better at many things than robots, and it’s more exciting to see humans on the other planets than it is to see robots. So, on balance, I’d like to see more investment in space science and less in areas like weaponry. Our taxpayer bailout of the banker gamblers who lost their bets in 2008 cost us about ten thousand times the entirety of what we’ve spent on NASA.
https://www.publicbooks.org/earth-first-then-mars-an-intervi...
This interview in particular is worth reading for this whole topic being discussed here.