The phrase
"desperate housewives" refers to a popular TV show about the complicated lives of women living in a suburban neighborhood. It implies that these women are feeling very unhappy, trapped, or dissatisfied with their lives and are willing to do extreme or unexpected things to change their situation.
Full definition