That's nowhere near a worst case for oil&gas. It's the most visible spectacular case. The worst case is mass extinction events due to climate change. The worst case that's actually happened is a million deaths/yr due to air pollution. Accidents are barely a blip in the calculus, the bulk of the damage happens even when everything is working as intended.
You don't have to sell me on the poisonous nature of oil & gas. It is a given that those are bad ideas and need to go away. The real debate is wind/solar/geothermal/hydro. Once pollution and climate change is removed from the equation, accidents absolutely come into the calculus.
