The Gemara (Kesubos 65a) is clear that in principle there is nothing wrong with women drinking.
It says that when a woman’s husband passes away, and her kesubah guarantees her right to be supported from his estate, we allow her money for wine, if she is used to it. The Gemara brings stories from a few notable individuals whose wives this applied to.
One of the stories is quite interesting, but it’s not for here.