It's the grunt-moan-gurgle sound that you make when something excites or arouses you, because your rational mind hasn't caught up yet with your animal instinct and you don't have the words to describe how you feel. Can be used equally well for sex, food, art, music, a hot bath, a good bowel movement (hence the Urban Dictionary entry) — basically, any intensely sensual or sensuous experience.