I am surpised in this era of uber political correctness this is an acceptable insult in all parts of the political spectrum.
Sexist overtone - It links being overly emotional with a piece of clothing worn by females.
Homophobic overtone - If directed at a guy it is linking him with female clothing and “hysterical” women. Ironically since it is often used to say a person is too political correct the expression is a politically correct way of calling the guy a fa***t.
_________________
“Self Acceptance is a process not a performance”
“You are autistic enough. And you always have been”
Professionally Identified and joined WP August 26, 2013
DSM 5: Autism Spectrum Disorder, DSM IV: Aspergers Moderate Severity.