The promise of what Starship can be is mind blowing for launching cargo and people. If they can't stick landings and end up only as expendable rockets, it will still be a large capacity and very cheap rocket that opens up myriads of possibilities.
But if they can nail the landings and reusability, it is the most significant step for the space industry since the first foot on the moon, that opens up the moon base for loads of cargo and people. Apollo only allowed a token photo opportunity for a handful of Astronauts and the capacity to go again was basically relinquished, Starship actually lets you take enough material (100 tons) and/or people to build and operate a full sized installation/base instead of a 4 person outpost (and a tent equivalent at that).
When touted Mars missions over the years were often thought of as a one way trip and carry a handful of people per launch window, there is an intention to try and progressively create a fleet of 1000 Starships to go each 2 year window, while mostly cargo, those rockets can carry upwards of 100 people each. It's like going straight from dugout canoes to ocean liners. Starship is a paradigm shift.