'Betelgeuse on steroids' sheds light on how rare massive stars die