I get where you’re coming from, but I think that’s wrong given the context. The OP was in response to someone saying they wish we didn’t spend so money on the space program. So we’re starting from a place where whether or not it is imperative is being questioned, and in response they pointed to its tangential effects.
Sure. But if those two groups can never see eye to eye it makes sense: one group feels good for moving towards an end goal, the other group gets positive side effects from relevant progress. Everyone wins.
To me there is no question about it, putting all eggs in one basket is always bad and diversification is good and the only reason not to explore space is short sighted thinking ("I personally don't get to reap the results in my lifetime so it is a waste to me"). Environmental issues on the planet also suffer from this.
It’s an argument about prioritization in a resource constrained environment. They’re saying there are bigger fish to fry. You can even be “pro-space exploration for its own sake” and still think it’s not a wise investment at a particular time. They aren’t necessarily mutually exclusive groups.
You're still stuck in the mindset that space is a means to an end. If your plan is to exploit space for resources, it’s proving my point. You’re implying space exploration is just a means for resources and not an end unto itself. The fact that you use "may" is implying you're stretching to look for a silver lining to justify the answer.
And at least with current tech, the ARM programs show its too resource intensive to make sense in that regard. In other words, if there are other short-to-medium term problems that are competing for that funding (ie reality), there isn’t really a good case to be made that it’s a good way to spend constrained resources
Nothing is generally an end in itself. You get somewhere and then you see more figurative places to go. But staying home is the best way to never know they exist.
This is a very SV, production-oriented mindset. Everything is a means to an end, to check a box, to move to the next. However, not everyone thinks that way. I'd argue it's not a particularly healthy point of view. If you extend it to its inevitable conclusion, every step in your life is only meaningful because it leads to the next...and ultimately everything culminates in one's death, meaning nothing except your death was of any meaning. I'd encourage you to read Oliver Burkeman's "Four Thousand Weeks" to get a different perspective on how some things are an end to themselves.
I think there's a case to be made that exploration is an end of itself (this is the case made in the movie Interstellar) but that seems to be different that the point the OP made and that you're arguing with resources etc.