The sad reality is that long before humans have explored the solar system and set up sizable colonies on Mars the present Ecological, Economic and Political crisis will (if we're not very careful, and we're not) have caused our extinction.
Of cause there's no way we could destroy all life, and it's just possible that anther species might reach our level of intelligence and again look with awe, out into the vastness of space, but I think the odds make it unlikely.
You would think that we would learn from the un-imaginably small amount of the Universe that is us, and how venerable we already are to processes absolutely beyond our own control that intelligent life is very unlikely and we should cherish it not trash it for the short-term gains of a small minority.

Viking proverb
"Pissing in your boots doesn't keep your feet warm for long"

Sad (some of the time), but still proud to be Human.
PP