This is the classic ‘Stan’ sound effect – basically when someone’s really into something or someone and they’re making it known. It’s become a pretty common internet thing, so you’ll hear it pop up in memes, TikToks, and whenever people are joking around about being obsessed with a celebrity or trend.