
As a woman i have never heard that sentiment expressed among other women. most women can enjoy sex without drinking. some might prefer a drink or two to calm the nerves, but i don’t think that impacts their capacity to consent so long as things are discussed beforehand and they are in control of their body
As long as they aren’t too far gone or incapacitated, legally and ethically, you don’t have to be sober to consent. Legally, in most states, the standard is to not be incapacitated, and to be able to understand and assent to the essential nature of the sexual act. Ethically, I’d say they should be able to walk fine, talk without slurring their words, and that to the best of your knowledge, they would consent if they had sober judgment and wouldn’t regret it after the fact.
Like if they enjoy sex more when they’ve been drinking, and recognize and are fine with that while sober, then that’s fine, but if someone is only agreeing to sex because their judgment is impacted from being under the influence, and wouldn’t agree to it sober, then ethically I’d say that’s a problem, even if not legally one.