I hate to say I agree with someone named Whateverer, but you hit it on the head. We have issues locally we need to solve. In 100 years we can still go to space. Same with 200 years. And we'll have tons of productivity improvements between now and then. But we don't have a public school system capable of producing scientists.

All that said - perhaps... perhaps... Perhaps the minerals and compounds needed to survive as a species are elsewhere in our solar system.