This is that drawn-out, dramatic “noosa” sound that gets used when someone’s reacting to something crazy or unexpected. It’s got that exaggerated, almost meme-like quality to it, so people throw it in videos for comedic effect or to emphasize a moment of shock.