The per pax price here would be astronomical. Starship launches are in the tens of millions of dollars per launch, and human rated spacecraft vehicles cost even more. Even if you are putting a thousand people onto the spacecraft (which is a stretch), you are looking at 10s to 100s of thousands of dollars per ticket.
Then you'd need the infrastructure to actually operate the rockets. That includes refurbishment, grounds crews, basically a whole Kennedy Space Center operating to launch these things.
And on top of that, you'd need an urban area willing to deal with constant sonic booms. Even one launch/landing cycle from these rockets is multiple sonic booms. The noise would be unbelievable. No urban center is going to allow regular starship launches out of it, so you'd have to go a loooong ways out. Which then means either a long boat ride or a short flight back to the city center. Which entails baggage transfer and potentially significant delays.
On top of that, space flight is not easy on the body. You can't just put grandma on a rocket and trust that it'd be a comfortable experience. Both the exit, zero-g, and re-entry portions of spaceflight are significant w.r.t. the forces they exert on the body.
It's a neat idea, but like all the neat ideas in the thread mentioned so far it's all marketing. Run the numbers yourself, think through the externalities. It's not like air transport at all.