I'm convinced that the reason this issue has so much visibility is because the reporting requirements have changed. Ten years ago, a DUI did not require a unit SITREP like it does today. The result is more visibility up echelon and the perception that there's a problem. In my 22 years, the incidence of DUIs or fit for duty problems has definitely gone down. I believe this is because of changes in society in general and creative leadership instituted at the O5 level. Back in the day, when I showed up "unfit" for duty, my LPO sent me home and chewed my ass the next day. Today, your BAC will be recorded at the door and your Mast will be automatically scheduled by Outlook.
The list of OPREP/SITREPs summary gets briefed to SECNAV and CNO a couple times a week and when up to two-thirds of the list or more is more often than not DUIs, ARIs, domestic violence incidents (most involving alcohol) and suicide ideations/gestures/attempts that also involve alcohol you do get where they are coming from with their focus on alcohol abuse. A significant portion of CO firings that involve alcohol doesn't help either.
But you have to keep it in perspective too, with an active duty force of over 300,000 the rate of those incidents (usually 10-25 SITREP/OPREPs total a day, not just the alcohol-related ones, and they included a few that didn't involve active duty folks to include civilians on base, etc.) didn't strike me as inordinately high or unexpected, actually a little on the low side when considered total numbers, they read more like a city police blotter with less violent crime. But when that is all you see every day it would be hard to see past it.
We kept a running tally of the highest BAC reported, it was up to 0.468 when I left.