I don't even think it's a sound. I tried to sound it out so many times before and I sound foolish lmao. But yea it's like a... "word" you use to explain your sexual desire. Imagine you're texting and someone sends you a hot pic of a celebrity you crush on and you reply like "UNFFFF".
Technically it's a literal acronym, as posted above, but most people pronounce it as just a noise or moan. Essentially it means the same thing. Basically just something used when you see a picture of or talk about someone you find attractive.