Except in a parallel world where we continued forward making advances in space we could already be a defacto post-scarcity species (as far as materials are concerned at least), exporting our heavy carbon producing industries to the Moon - simultaneously helping create an atmosphere there, while avoiding any climate impact here, have effectively infinite land to expand outward into, countless high paying jobs perpetuating all of this across the entire solar system if not beyond. And so on endlessly.
Instead we're sending toy rovers to Mars, unable to solve climate change in any way that has any chance of actually moving forward, trending rapidly towards WW3 as nations' schemes invariably turn towards each other, with no grand outlet for expansion/growth to otherwise occupy themselves. And so on endlessly. I think it's quite a poor direction we've chosen.
And I'd also add that this is assuming there are no revolutionary discoveries out there awaiting discovery. It's basically impossible to imagine something like electricity/electromagnetism before its discovery. As we live on a single planet in a virtually endless - and ever stranger - universe, one can only imagine how many other revolutionary discoveries, things we cannot even really imagine today, await our eventual discovery. It's hard to know what we don't know, but I think there is probably a rather tremendous amount. And it seems reasonable to expect that exploring the cosmos is one way of taking us closer to it.