Betelgeuse Supernova: Unleashing Cosmic Intrigue as Earth's Fate Hangs in the Balance