Scientists Unveil Rare Celestial Spectacle as Comet Graces Earth's Skies