People will make this sound when referring to something that is very kinky or sexual in nature, usually as a joke to friends. The noise itself is just making fun of the music played in the background of 70s porn.