Jack it's a Darwinian thing, if they're too stupid to have a gun they'll weed themselves out.
I'm a ccw permit holder I never drink and carry, nor do I carry into bars, hospitals, daycare centers, churches, Courthouses or anywhere it's illegal to do so.
I also don't ghetto carry, I use a properly designed and secured holster and if the pistol has a safety I use it, some ccw firearms don't have safety levers and are shall we say risky.
Booze and guns don't mix, you of all people know that better than most having owned a bar.
Will people do it, yeah they will, if they don't die from stupidity they're lucky, if they're caught by LEO then they should lose the gun, lose the permit and be banned from ever having a ccw permit again. A ccw is a "Right" and a privilege and if one fails the test then the privilege is revoked for good.
I wish the same could be said for 502 drivers, make the penalties as harsh as possible.
I've lost co-workers and friends due to drunk drivers more's the pity. It's a sore issue for me.
Just one man's opinion here.