“fun to think about” covers the best questions posted on here
In the event we do sort our shit out with earth we’re still eventually going to need to expand because a. Humans like to multiply and b. All the wind turbines and carbon policies in the world won’t protect us against a big fuckoff meteor
Space stations definitely seem easier and less destructive in the short term, but also if life support fails an entire colony of humans dies
There’s a cool sci-fi book called Children of Time that covers that topic
The other thing it covers unfortunately is that politics will ruin any efforts to actually do something about a situation