I wouldn't be too worried about tourism replacing the "spirit of adventure" that is space exploration. We've explored LEO and gone around the Moon before, there's nothing left to explore there. Landing on the Moon and Mars is a different story, and one you're not likely to see commercial companies do for a long time.