Again, again and again, SpaceX is about commercial space activities that can with a bit of luck generate an income. Which means low-risk mission profiles and valuable payloads, which are currently commercial (communication) satellites from all around the world. The main competitors are ILS (Proton) and Arianespace (Ariane, Soyuz, Vega). Maybe we'll see a few other like Orbital Sciences come in, but the market has its limits.
US-Government contracts consisting in unmanned or eventually manned deliveries to the ISS might be bonus. Space tourism, IMHO, is going to stay a very marginal activity. The ticket is still way too expensive and the selection process (health) makes the suitable public limited.
The idea, from the start, was to relief NASA from those "housekeeping" tasks and let it focus on the risky, deep-space exploration missions relying on cutting-edge technologies. Which do not earn money, and cost a lot, but that's the story of fundamental science.