This sounds like a short-lived view to me and the exact kind of sentiment I hear in the climate-change skeptic circles. It is one thing to have a handful of humans survive in an underground bunker somewhere, and a whole different thing to have the species colonize the Galaxy. One is barely surviving and the other is thriving.
You cannot deny that our best bet for long-term survival is to get off this planet. Musk is perhaps a rich idiot, as you put it, but at least he has the right vision.