The sound comes from Team Fortress 2, Valve's class based shooter released in 2007, where the Demoman is the Scottish explosives expert obsessed with scrumpy. His death lines were recorded as short in game barks, but players ripped and shared them outside the game on forums and video edits. The bottle line followed by an explosion became a standalone meme because it tells a complete joke in two seconds. It is still reused as a scream meme for gaming deaths, Garry's Mod videos and TF2 remixes where an exaggerated demise is the punchline.
About this sound
The Demoman death scream from Team Fortress 2, where he yells about his bottle before blowing up. Creators use it for over the top cartoon deaths.
This clip is the Demoman from Team Fortress 2 in his final seconds, cheerfully slurring about his scrumpy bottle before an explosion cuts him off and he lets out a long, drawn out scream. The delivery swings from drunk confidence to pure panic in about two seconds, which makes the timing feel inherently funny. The scream is loud, ragged and unmistakably Scottish, and because the joke lands before you even see anything, editors use it as an instant punchline for a character who has clearly made a terrible mistake.