It will take a really long time before any off-planet colony could be self-sustaining. Just think about how long the supply chains for even the simplest things needed for repairs are. Until then Earth is either fucked due to climate change or we have a local solution to the problem.