I would argue that if you had companies operating on the moon/mars then that would require some level of labourers - so I think the same way we have off shore drilling , we could see the equivalent option open in the work force. Off planet drilling, off planet mining, etc.

To answer your question though My definition of space tourism is definitely the equivalent of a carnival cruise line space ship that takes you on excursion trips to the moon and mars.

I know we constantly hear about x, y and z investor planning to build moon resorts and various moon based companies…and obviously Elon is constantly pushing ambitious agenda, but I never understand how realistic these goals are and what timeline they are realistically looking at.

I know we are in a period of time where technology is rapidly advancing like none other in history, which makes me wonder if these ideas are more than just ideas but potential reality before the end 2060-2065?