For what?

The point-to-point travel on Earth is no less vaporware than the Tesla truck. No, not the Cybertruck. The EV truck envisioned to eventually run with FSD. The thing that sounds revolutionary until you do the maths and realize it can transport barely any cargo compared to all existing alternatives because of the weight of the batteries it needs, even if you use the most optimistic pie in the sky promises of storage efficiency Tesla published at the time. Even if you ignore the health issues (e.g. horrible G forces, travelling on a massive tank of explosives) to do this safely requires such a distance between the "spaceports" and population centers that it barely comes out on top of existing aircraft (let alone high speed aircraft like the Concorde, which was ultimately scrapped because the speed advantage wasn't worth the drawbacks).

So this leaves either travel to/from a space station or travel to/from a planetary body.

The ISS is a research project and already showing its age, so "space station" probably would have to be something else. Humans don't deal well with prolonged stays in zero gravity, so a "space hotel" is probably not going to work out even if you work out the economic problems and ignore the social ones (e.g. staff either having to be cycled out very frequently or being worked to death). Building "space infrastructure" comes with many of the same problems but also requires continuous resupplies, which will still cost an incredible amount of fuel if the cargo is at all heavy (as industrial supplies tend to be).

The moon could be a more practical idea given it at least has some semblance of gravity and at least shields you from the cosmic horrors on one side (i.e. from below) but any attempt at permanent residency would still impose massive health problems and require a constant stream of supplies and moon dust simply isn't all that profitable a resource.

Mars sounds cool but is simply too far away. Any attempt to make it hospitable would likely take on the order of thousands of years if not more while still requiring a constant stream of supplies (but now at an even greater distance, a much more constrained time window and with radio communication having a very noticeable delay). Plus anyone actually going there would have to not only not go crazy on the journey but also maintain mental health sitting in a featureless desert with no atmosphere and knowing that this is where they will die.

Space is exciting, but humans are very much made for living on Earth and any attempt at expansion will require first stabilizing life on Earth for at least the next few thousand years -- which is pretty much the opposite direction we're currently heading in even if you ignore Climate Change. A bigger badder rocket ship won't change that.

Don't get me wrong, I very much used to be a Musk stan for a while too and I actually got the Hotwheels model of the Tesla he sent to space sitting right next to me right now, but even at the time I realized that for all my excitement about that stunt, nobody outside my tech bubble actually cared about that.

Reusable rockets were cool outside my bubble, for about the thirty seconds it took to watch the recording. The black hole I mentioned was met with amazement, but realistically the reactions were in the same ballpark as those to the usual "super moon" news reports. None of this stuff had a profound impact and neither will a bigger rocket or a new space shuttle.