Active Duty Navy here. The O'Club out at NAS Fallon is still alive and very much so kicking. Fallon is home of Top Gun and most fighter squadrons do detachments out there to spruce up on tactics. Fighter Dice and trying to sneak up on the bar to slap a squadron sticker higher than the other guys before the barmaid catches you is still very much the name of the game. I was also invited to the CPO Club at Fallon and can verify it is likewise still running its A game. During our 1 month detachment out there both were open every night and every night we were in there partaking. It was described to me by some of the old Tomcat drivers that Fallon is the last true O'club still running out there. I've still got free drink chips from there for covers on the counter and any other sort of shenanigans.
Naval College in Monterey still had an O'club and it wass active with all of the folks going through the courses out there as of 2010.
In Bahrain on deployment the O'club and CPO club were both hopping but only as a stopping point for most to grab a few more beers before returning from liberty because lets be honest ... you gotta be kinda drunk to willingly get back on board a carrier to tool around in the heat for another month or more before you get to touch land again.
The O'Club and CPO Club at Pearl Harbor are both closed though the "enlisted" club is still open but serves everyone of all ranks.
The O'Club at MCB Kaneohe Bay is still alive. They do a great spaghetti buffet one day of the week and otherwise serves great food with an amazing view. Not sure if its open for drinks though.
Hickam AFB's O'Club was similar. I know they did dinner during the week but I'm not sure if they had an active bar scene or just mostly dining.
The O'Club at NAS North Island was open the one time I was up there but it may have had more to do with the Admiral wanting to catch a drink with all of us after our community brief. That said the glasses were all hanging on the ceiling so it does get some use, but probably only one day a week. Same with NAS Oceana.
NAS Whiting Field does their winging ceremonies in the O'Club still and it opens on the weekend for those staying there on TDY orders for training. The gal would also open the bar during the week if we could get at least 10 people to commit to coming down and drinking. Otherwise she'd drive us into Pensacola to party. Pensacola's O'Club was open and doing lunch/dinner as well. Never went down there to drink though.
The O'Club at Sub Base New London (Rotten Groton) was still functioning when I did SOBC there back in 2011. It was only open on Friday if I remember right, but the local VFW would donate something like $400 each week for wings and beer. So you ate and drank for free until the money ran out. The senior guys from the boats loved to come up and talk to all of the SOBC students on Fridays at the O'Club. The CPO' Club was open as well but I think it was open Friday AND Saturday.