It’s funny, our Shul has been “DRY” for about 5 years now. At the time our shul made the change, we lost 3-4 members but since then we have noticed a plesant change of the decorum on the “drinking” holidays. It has become more family oriented with just as much Lebidikeit. In Lakewood, my parents shul also make a takanah/rule of no one being allowed to drink (after last year when a kid was almost crushed by a falling drunk man…to be honest I don’t know if this was the straw that broke the camels back but there was enough of a voice to make the change) and there was a positive change noticed there as well.
So why should they make a stink…..because they should. There is no mitzvah to get drunk, there is an avera to one who brings disgrace to a mokom of learning (Ie: inappropriate behavior, throwing up and danger to small kids)It can and does change. Why should the people who want to do what’s right have to give up on what they want because of a bunch of grown up who want to act like kids (as well justify a reason for getting drunk)