A little quick research shows that Falcon 9 has had one in flight failure out of 86 launches. So it is high on the list in terms of reliability, but does not have a perfect record. I would go on that ride if I had the chance.
However, the Starship clown show in Boca Chica does make one wonder if they developed Falcon 9 under similar conditions. And, every time I watch an implosion video I have to wonder how in the heck it is going to withstand off-axis aerodynamic forces and other loads when transitioning from skydiving to tail landing.