One of the problems is that in the good ole' days not anywhere near as many SNA's or JO's were married with kids. There was a time when SNA's were required to live on base. That meant many more good O' club nights. Now with more families in the JO ranks, MWR budget cuts, and PC after tailhook we have a perfect storm for the clubs to suffer.
I think Kinngsville club is actually OK. They have beer from 3 to 7 (or longer if they have business) on Wed, Thur, and Fri. I had my O-5 wetting down while a couple of guys got wingned there a couple of weeks ago and we all had a BLAST. Lots of crazy dancing, some good local "talent", and CHEEP booze. The duty driver was made available to get people home and both the base CO and Commodore stayed way late.
If the students can take just a piece of that back to their fleet squadrons, maybe along with some of senior leadership, they can get some of that "esprit de corps" back into the clubs.