This is a pretty absurd sound effect that’s basically become an inside joke in internet culture. It’s the kind of thing people throw into videos when they want to be intentionally ridiculous or shock value, usually paired with something equally ridiculous on screen.