This is that iconic screaming sound from the anime/manga character Doctor Octagonapus. It’s basically a guy absolutely losing it with a high-pitched wail that goes on for a few seconds. People use it for comedic effect in videos or when something ridiculous happens.