At present, we are transforming Earth to our short term needs, but against our long term needs. The timescales don't match, because expanding to space should take several centuries, but we are risking wrecking the planet after only two centuries of industrial civilization, roughly. So it's wise to be afraid of extinction.