It's funny how people can look at the exact same program and draw wildly different conclusions. From where I'm sitting, Starship is a deeply flawed and highly risky program with an uncertain future. There are two keys problems:
1. It's not clear what the product-market fit for Starship really is, specifically there is limited demand for these super-heavy payloads. What's my evidence? Falcon Heavy. It averages about 1 launch a year, typically by the military, compared to >100 for Falcon 9.
There are five standard counterarguments to this:
a) "You can carry multiple payloads." Most of the time this simply isn't true. The payloads have to be on almost identical orbits for this to work. Different inclination? No shot. Different altitude? Almost no shot. This brings us to the second;
b) "But Starlink." Yes, Starlink can take advantage of this although to justify its massive expansion, Starlink really has to launch a satellite-based handheld mobile phone network and it has to be pretty much global. It's unclear if this can be from a legal and regulatory standpoint or if it will be able to effectively compete with traditional terrestrial 5G networks. It's unclear what customer density can be supported;
c) "It will induce demand for bigger payloads." Falcon Heavy is relatively cheap, particularly compared to the alternatives from Ariane and ULA yet launch cadence is still particularly slow. Satellites, which are the bread and butter of commercial rocketry, just don't need to be that big;
d) "Starship will replace Falcon 9 launches." Yes, but other companies will fill the Falcon 9 gap if SpaceX abandons it. If you're only carrying one payload to LEO (or even geostationary orbit) and you can do that with a smaller launch system that you can reuse, it's simply going to be better eventually; and
e) "Space based AI data centers." This is never going to happen. it doesn't make any sense. You can't get enough power or distribute the heat. You're subject to cosmic rays and solar radiation, which the atmosphere otherwise mostly protects you from, and you have no way to economically service the inevitable failures.
2. The whole Mars thing is BS, basically, kinda like space-based data centers. It's not happening. There's absolutely no reason to go;
3. Starship isn't suited for lunar missions, which is one reason (IMHO) why Elon tried to scuttle NASA's lunar program [1]. Basically, a 40 meter high vessel that has to land horizontally is hard to land, hard to get in and out of (with your astronauts 40 meters off the surface) and much harder to get off the Moon and back to Earth.
4. Between (2) and (3) a whole lot of new capabilities have to be developed anyway, none of which have even begun yet (eg in-orbit refueling).
Now the one really useful thing from the Starship program (IMHO) is the Raptor engine. For context, the Falcon 9's Merlin engine used oxygen and RP-1 (kerosene, basically). Only the oxygen had to be kept really cold. But it has coking issues (ie solid carbon build up from the RP-1 being consumed). Raptor replaces RP-1 with LNG. No coking but now you have two cryogenic fuels instead of one.
[1]: https://futurism.com/elon-musk-scrap-nasa-moon-program