> The case where Mars becomes very interesting is if Earth becomes uninhabitable for some reason

Yemen is quite inhospitable, but people still prefer Yemen to living in the Sahara desert or the Antarctica.