This scream comes from Soldier, one of the playable classes in Valve's Team Fortress 2, released in 2007. Short voice clips from TF2 spread widely through frag videos, YouTube edits and meme compilations because each class has a very distinct personality. Soldier lines in particular are popular for loud, exaggerated comedy, so this scream keeps showing up in gaming posts whenever a moment needs instant panic or slapstick impact. It sits in the same broad gaming-sound space as enemy callouts and dramatic failure sounds.