A comet nicknamed the “Halloween comet” disintegrated on Monday during its closest approach of the sun, and the European Space Agency and NASA’s Solar and Heliospheric Observatory mission captured footage of its final moments