Nancy Boy is a nickname/slur for effeminate and/or homosexual men.

It's an old fashioned term for a gay guy.

It is almost exclusively used these days as a derogatory slang term for either a gay man, or for a man who lacks traditional masculine qualities.