This is a so-called 'wicked' problem. Choosing to go to Mars is not as clear cut as it seems on the surface.
Calling the project 'resource intensive' is one thing, but pointing out exactly where it consumes an unreasonable amount of resources is a totally different ball game.
Context matters, and things can look very different depending on what you compare against each other. Arguably, the actual rocket, astronauts and supplies send to Mars only count for a negligble fraction of what's available on Earth. But things change when you take a step back: there are many layers to the story. You need infrastructure and people here on Earth to actually assemble the mission: specialists, technicians, management, buildings, factories, supply chains,... And if you zoom out even more, you see that you need sturdy civic infrastructure to support all that: education, roads & bridges, domestic and foreign policies, international trade deals, defense and so on. And all the people involved to support all that have to attain a living standard above the poverty line which allows them to focus on all that. So, now you're looking at essential economic sectors which need to support all of that.
Turns out that the 'resource intensiveness' isn't concentrated on a specific point. It's diluted, it's hard to track, and there's a fuzzy line with questions like 'is this resource clear cut spend on an, arguably, wasteful Mars mission or something else?'
> As a species we
I always get skeptical whenever 'we' is used in an argument. Especially in reference to humanity as a species. Humanity isn't a collective consciousness able to think with a single mind. It's billions of individuals that all act on their own accord and any collective behaviors that can be observed are emerging dynamics.
Sure, you could argue that sovereign nations consists of millions of individuals rallying together and aligning their behavior towards common goals. But those are always informed by a complex interplay of trade-offs, incentives, benefits, external conditions, and so on. In the grand scheme of history, even nations aren't forever: they come and they go over time.
The hard reality is that either going to Mars, or curbing climate change aren't self-fulfilling prophecies simply because several vocal groups want them to become reality. They only become reality through complex dynamics over which individuals have far less control then we might assume about ourselves.