This will be a bit difficult to answer, I think I'm unable to answer. First of all: it is very hard to talk about subtleties of meaning and interpretation in written language. Second: english is not my first language. So please interpret my text as amicably as possible.
"Are you claiming it was appreciative of women back then?"
I think it depends very much on context, who said it, where does it get said, to whom and in what type of voice etc. The saying "Wein, Weib und Gesang" as such could be appreciative towards women, and I think it could be said in a non-demeaning way, also in the times, where women had a much worse standing as of today.
I think this, not because I know anything about that time back then, but because I learned in the last decades how heavily the perception or meaning of words can change. And how very personal those perceptions are. When I went to school, we used words casually, that would be offensive today. And I know that my friends and I used these words without thinking twice if they're offensive, because to us, they just weren't. Others could be offended by those words at that time. But this is because other people have a different moral, or knowledge, or education, or age etc.
What I want to say with all that: we are almost unable to comprehend how people back then thought, talked and meant the stuff, they said back then. Because we are pretty much blinded by our own current perception and moral of things. For example, I tend to think amicably about the past, so my interpretation of stuff that was said in the past gets a "rose tint". Others tend to think that the past was bad, people were stupid and crass, and wrong. So they interpret things in a much darker light, than me. I can't say that anyone is more right than the other, because it comes down to very personal interpretations.
> It was expression about loud wild partying, the sort of that is annoying to everyone living on the same street as your beer pub is. The women who were present were not appreciated, they were look down at sort of tramps. A well behaved woman was not supposed to be present.
This is what you learned and interpreted about that phrase and time. For me this is a possible situation you describe, but there are also very different situations, where this phrase could come from. In my social circles, the word "Weib" was used in a very endearing, appreciative way towards women. Women used that word for describing themselves as strong, and emancipated. So the phrase "Wein, Weib und Gesang" could have a very positive connotation. That says nothing about what happened a few hundred years ago, it just shows how personal language in the end is.