This is one of the reasons why space travel will never be 'routine'. A million and one things can go wrong, and any one of them can destroy the spacecraft. Compare that to commercial air travel - where a number of unlikely events have to happen, to down an airplane. Some time ago, there was a HN discussion about traveling from continent to continent in minutes, using a sub-orbital hop. I don't know about anyone else,…
Airliners are fully capable of turning themselves into fireballs. It doesn't happen often because we have a lot of experience operating them. The same safety levels are possible with rockets over time.