Thinking about wild scenarios is fun and sometimes even prudent.
But acting on it at this point is tragic premature optimization. Musk isn't a stupid person so I have to think in his heart he knows his story is more about PR and being seen as a visionary as something that will actually be done in the next thousand or ten thousand years. Even if there is some climate catastrophe that causes 99% of the population to die out and any civilization to collapse, the remaining 1% are better off on Earth than trying to spend their limited manpower to get to Mars, even if some crazy trillionaire has established a beachhead there.
As an analogy, it feels like some person living paycheck to paycheck and having only $20 to spare at the end of each pay period and saving up that money ... not to invest it in some way that improves their lot, but to hire a tax attorney to help them plan how to shelter $1B in income in case they win the lottery.