After the Shuttle program ended in failure, work on reusable launch systems stopped for decades. A similar thing would happen if Starship fails. Space would remain the province of the military and large governments.
Today it costs ~$3,000 per kilogram to put something in orbit (on a SpaceX Falcon 9). Starship aims to lower that to $10 per kg. That's totally crazy, but even if it could get it down to $300 per kg, that would revolutionize access to space.
Data centers in space, biotech manufacturing, and maybe even asteroid mining and energy generation become practical at those prices. To say nothing of telecommunications, remote sensing, and global navigation--all become much cheaper.
And, of course, that drops the price on all the cool science/exploration goals that we always talk about: massive space telescopes, regular probes to all the planets, and crewed exploration.
We're literally at an inflexion point between two possible futures and we don't know which it's going to be. If I were younger I would absolutely try to work at SpaceX to help tilt the chances.
But as it is, all I can do is root for them.