Gay was the 795th most common given name (forename) in the USA in 1990, and Gaye the 1,295th most common female given name in the same year.
I am in the UK and have a cousin aged in her early 50s (?) whose middle name is Gaye.
Gay is also a fairly common surname - for example, Tyson Gay, the sprinter.
I have spent much of my life in a Morris dance/folk song environment, and English folksongs are full of gay fusiliers marching to war, and ploughboys (US = plow boys) rising in the morning, bright and gay.
Of course, the word is now commonly used either as an adjective or noun in connection with (mainly male) homosexuality. That does not in any sense detract from its other meanings.
However, for a long time, back in the 1980s or thereabouts, when the word occurred in a song, it often invoked a smirk at the "double entendre". These days, we are generally more aware of and comfortable with homosexuality, and that double entendre effect has sort of died a natural death.
I don't know about the USA, but in England, the word "randy" means "horny" or "ready to have sex." Back in the 1980s, there was an American guy who worked at a scuba dive centre I used to use regularly. He once rang me at work unexpectedly (I think to tell me a piece of kit I'd ordered weeks ago had come in) and I picked up the phone to be greeted with, "Hi, Mike, I'm Randy." Didn't half surprise me until I worked out who it was!
