From a lamens perspective it all looks terrifying. People sitting atop thousands of pounds of jet fuel which is burned at incredible force.
There must be so much that can go wrong but perhaps some of the fundamentals are being solved by SpaceX (and others) to the point that some of the previously scary stuff is more so part of a boring checklist?
I know there’s a few rocket scientists around here :)
For falcon+dragon I’d guess the probability of a failure (no orbit) is 2% ish and loss of the crew is 0.5% ish.
The jet fuel by itself is not so bad because it needs to mix with the air to burn (you can often get away from an airplane after the crash before the fire is dangerous.) but with the liquid oxygen it can go off like a bomb.
But really they have launched many falcons so it is pretty routine.