This sound comes from Sekiro: Shadows Die Twice, the 2019 action game by FromSoftware. It plays with the game's perilous attack warning, paired with the red danger symbol that tells players an unblockable move is coming. Because that cue is so memorable and stressful in actual gameplay, it spread into gaming edits, meme clips and boss compilations online. Creators still use it because even people who have not played Sekiro can read it instantly as a danger alert with real stakes.