Well, that's one way for a woman to orgasm. There are at least 9 others.
That's true, more specifically, it's the filling of the skene glands. Female ejaculate has only trace levels of urine from the small distance it travels down the shared urethra.
As for the mental associations, of course...