https://www.nasa.gov/content/commercial-lunar-payload-servic...
Granted, it's a monopsony for now but...
Also, the next market might be "companies who want to mine asteroids for rare metals or rocket fuel", in which case SpaceX may be in the "sells pickaxes to gold miners" business.
Those who pursue asteroid mining would do well to review the history of recently dormant or acquired companies such as Planetary Resources, Deep Space Industries, and Shackleton Energy Company.
That said, I agree that some of Elon's longer-term goals in space are somewhat more questionable from an economic perspective. Safety is still a big question mark when it comes to tourism and intercontinental transport, and a lot of the other proposed uses (such as Elon's goal of settling Mars) have questionable economic value. Will be interesting to see if any new markets get created by Starhip's record low launch costs.
Because of that, I would say starship still has to prove it is commercially viable.
Space tourism, in particular, highly depends on how safe one can make the trip. A 1:1000 risk of death likely would make many would-be passengers think twice before booking a trip.
It also would depend on making the trip nice. The first few tourists might go for bragging rights, but after that, one would need attractions in space. Building those there will increase the cost of a trip.