Will alcohol affect his fertility?

My fiancé and I are planning to TTC later this year when he gets back from being overseas. Now, he is not the healthiest man with some of his habits he has. He suffers from insomnia and only get a few hours a sleep or non at all, He is a heavy drinker(he has taken a break for a month before but he’s seeing his best friend when he gets back and will be drinking very heavily with him), he vapes a lot, and just over all doesn’t take care of himself aside from working out a lot and eating healthy.

He wants a baby, and I have been married before and have a history of fertility issues. I’ve had 5 miscarriages. So I really plan to get healthy before we TTC.

Here’s the issue... we looked at his sperm and the count is so low with low mobility.. I on the other hand I get pregnant easily. He won’t stop vaping or drinking when TTC. I’m really sad... I’ve been waiting so long to have a baby...

If he takes vitamins and supplements to help boost his sperm count, will that help at all?

I mean there are alcoholics out there that get women pregnant all the time...