This sound is from Deep Impact (1998)

Deep Impact is a compelling disaster film released in 1998. Directed by Mimi Leder, the movie depicts the catastrophic events triggered by the discovery of a comet set to collide with Earth. The star-studded cast includes Robert Duvall, Téa Leoni, Elijah Wood, Morgan Freeman, Vanessa Redgrave, and Maximilian Schell. Their brilliant performances capture the intense emotions and gripping narrative as humanity faces imminent destruction. If you are a fan of heart-pounding thrillers, you can play and download the sounds from Deep Impact here.