Y'all are way too timid at predicting the future of space.
There is an old puzzle about yeast that doubles every half hour, and fills the container at 7PM. When is the container half full? 6:30PM.
There are four basic curves to apply to prediction of things such as this.
First is an exponential decay, the blue line. This is the case when interest in something dies off. Space travel is unlikely to follow this curve since there is a great deal of money in it. Today it is making profits for lots of companies.
Second is a constant curve, the dark orange line here. Again, this is unlikely for space travel.
Third is linear growth. SpaceX is already well past this.
Finally there is exponential growth. This follows when the activity becomes self-increasing.
Starlink alone is quite interesting. They are already making $300 million/year. The cost to put up the expected satts for the network is $600 million.
https://www.forbes.com/sites/johnko...booking-over-300-millionyear/?sh=43ee0da27063
SpaceX is already well past self sustaining. Musk can afford quite a bit of rocket development with even those numbers. Falcon Heavy can take 64 metric tons to low Earth orbit. His plans for Mars include something like a FH launch per day starting in a few years. And he has bigger rockets in the testing phase.
He can afford to blow them up on a regular basis. Blowing up rockets is a big part of the process of learning how to build them.
In 2023, SpaceX is doing roughly a launch per week. This is double what they were doing in 2021. They are on the exponential curve. And their doubling time seems to be about 2 years.
And yes, lots of people want to go. For a variety of reasons. There are lots of technological manufacturing type reasons. Lots of things possible when you have plenty-o-free vacuum. And when you have sunshine not interrupted by clouds. And when there is no environment to pollute. Want to store a million tons of arsenic? Put it over there and just watch where you walk.
And yes, tourism will be a thing, if the price gets low enough. The energy costs to low Earth orbit are similar to the energy costs from New York to Australia. Getting to the Moon roughly doubles it. Ordinary people ought to be able to afford a trip to the moon. If they can, and if it becomes as safe as commercial flight, millions will.