Not this type of tourism. It might make a small amount of money, but there is no huge market for extremely expensive (think a hundred thousand dollars per trip per person) but 0-comfort exploration of barren wastelands that you can't even see for more than maybe an hour or risk being radiation poisoned. Will there be a trickle of extremely wealthy dare-devils? Sure. But this is neither a Greek island nor Monaco.

Even his cheapest estimates are still in the $100,000 USD range; I don't think you can support enough tourists to colonise Mars when the ticket alone costs that much.

I can see plenty of people going to Mars — religious groups, cults, anyone who wants to explore the final frontier, the most extreme preppers (which Musk arguably is given his "multi-planetary" arguments), and anyone who would like to build their own mountain-sized space castle.

What I can't figure out what any of those people might sell to Earth such that people on Earth are willing to trade for it, except for information which people on Earth can also produce without paying so much for a ticket.