In this regard, the comment about CO2 is actually much more pertinent than it seems at first. If we manage to screw up the climate in this century (which seems very likely these days), inundating every coastal cities in the world, "sustainable space colony" will have to wait a bit longer. Much longer. If you're worried that an asteroid might hit us 500 years from now, you might want to rethink your priority.
Advancing chemical rockets now is important, but compared to the scale of space colony, it feels somewhat like producing better vacuum tubes to make sure (say) the US is the first to create strong AI. Any sane 50s US leader would have understood that "trying not to have a nuclear war with Soviet" is a much more important goal anyway: you can't fund AI research if your country is a radioactive wasteland.
We went from not flying anything heavier than air to going to the Moon in 66 years. If we really really wanted to, we could go to Mars in thirty. This is a problem of priorities, not technologies (although the technological problems are real, they are not insurmountable).
CO2 is a direct and immediate threat.
Unless the lead time is 50-100 years, years might as well be tomorrow, it's going to kill us all either way. Even that might be stretching it.
> Humans as a species will survive CO2
Maybe, personally I believe humans will cause their own extinction. I'm just not sure yet if we're going to take all life with us or not. Dealing with CO2 is a toss up between making the planet uninhabitable or completely inhospitable to life.
Space travel is fundamental to the human species living sustainably in the long term. Correcting greenhouse gasses doesn't help us if the next day we find a planet-killer asteroid is a few weeks away.