I have found that at Purim meals where no one gets seriously drunk, everyone tends to have an equivalently-good time. How good a time that is, of course, depends on the quality of the company, conversation, etc., just like at any other gathering. If you're looking for a great source of both holy and fun holiday-appropriate conversation-starters, I recommend our free Purim book, Purim - Mi Yodeya?.
Conversely, at Purim meals where some people get drunk to the point of severely impaired judgement, others at those meals who choose not to attain that state, of any gender, tend to have a less good time as a result. I would advise people who want to enjoy the holiday without getting seriously drunk to try to avoid gatherings where others do.
In particular, if I was a woman with children whose husband was intent on getting seriously drunk, I would consider having him attend a meal with like-minded individuals (making sure that he has a safe way to get home!) and attending or hosting a separate meal for people in my and my children's situation. I am not in that situation, so I can't testify personally as to the effectiveness of this approach.
I can testify to this: A couple of years ago, I decided (beli nederbeli neder!) to not drink enough on Purim to noticeably affect my behavior, where my previous practice had been to get drunk enough at the Se'uda to act pretty silly. This decision was influenced by multiple rabbis that I look up to preaching against Purim drunkenness year after year, as well as by my wife's annoyance at my relative uselessness, while tipsy, at dealing with the kids. My wife reports (and urged me to add after I showed her the previous paragraphs of this answer) that her Purim experience has, in fact, been enhanced by my drastically reduced inebriation and consequent enhanced usefulness.
