Depending on cost, Starship could fund itself purely off space tourism. Numbers as low as $100 per kg to LEO are flying about.
If SpaceX hit something like that, we enter a whole different paradigm because a trip in relative comfort to orbit becomes comparable to middle class holiday prices.
If you can send an average person to orbit for the price of a trip to Disneyland, your launch demand functionally becomes infinite. This would become the thing to do for so many people.
It's sort of like CPU manufacturing: making a CPU is a peak technology, multi billion dollar undertaking - but because we can sell the things for like $250, everyone on the planet now has one.
Space access may go the same way if SpaceX get anywhere near those lower numbers. Blue Origin did one interesting thing recently, and that was launching William Shatner suborbital - if you can send a 90 year old, you can send anyone.
Building the official hotel would become the next obvious thing, complete with spin gravity. It would be a while new dimension.