Neutron Stars: The Cosmic Powerhouses Born from Supernova Explosions