This sound comes from JoJo's Bizarre Adventure: Stardust Crusaders and is closely associated with Noriaki Kakyoin's cherry scene, where the repeated rero rero noise became instantly memorable among anime fans. The clip spread through anime meme pages, reaction videos and short edits because it is so distinctive without needing any extra context. It is still used as a shorthand for weird, uncomfortable or hilariously offbeat moments, much like other recognizable JoJo audio such as To be Continued (jojo).