This is a true story but names changed:
Many years ago, I had a boss, lets call him Simon, who drank a lot, and smoked too. He was an accountant, quite high up, in a well thought of firm, & so earned well.
He took pride in the fact he was younger than the other bosses and had achieved a high level of employment in not so many years since he graduated. Had the nice company car, a lovely house in commutersville and a really nice girlfriend, super holidays etc..
However he did like to drink, often to excess, and loved his food too. Any coprorate function he'd drink several pints and a few shorts and would be lucid and credible but it was borderline before he would make an idiot of himself, we had to manage him and keep him away from the bar or he'd just order more & more! Consequently he was very overweight, and he looked permanently ill, often quite yellow. And he snored a lot. After much insistance from his gf he booked himself via his private healthcare at a top clinic. Lovely doctor, Mr Hing, who in examining him was chatting away, asked him about his job, his lifestyle etc : 'Tell me, Simon, do you contribute to a pension?' 'Oh yes' said Simon, priding himself in having his life all sorted out....'Well I wouldn't bother contributing any more' said Mr Hing, 'you won't be needing it!'
This shocked 'Simon' into dropping the drink, and the fags, shedding half his bodyweight, joining the gym, swam for miles, and turning into a fitness freak. He also stopped snoring. Went back to visit Mr Hing and was told his life expectancy had increased considerably to being normal for his age weight and height, and that he could indeed look forward to drawing some of his hard saved pension. Up until the point of Mr Hing's pronouncement, 'Simon' did not think he had a problem with his lifestyle (we all told him he drank far too much, as did his gf, but if fell on deaf ears), he certainly didn't think it had any impact on his life, and was nothing to do with his snoring!
I think you are worried about your OH's life expectancy and the effect of him drinking to excess and ultimately loosing him to an alcohol related disease would have on you & your family.
I think your OH is more concerned about what other people would think if they knew about his alcohol 'problem' - which he doesn't see as a problem because he can (still/just) control it, and he doesn't seem worried so far about the effect the alcohol is having on his health. It might take him a while to understand where you are coming from on this, but he has to take the decision by himself to improve his lifestyle and health, and long term life aspirations, not you.