This sound comes from the Zombies mode in the Call of Duty series, where the nuke power-up eliminates the enemies on the map after a short delay. The audio became familiar to players through years of round-based gameplay and later spread into gaming edits, shorts and meme compilations. It still gets used because the cue is instantly readable to many viewers: one pickup, one blast, and the whole situation is over. That clear meaning makes it useful far beyond Call of Duty clips.