How long til his body will give up?

My husband has been addicted to pain killers / opioids for around 2-3 years now, on and off. Around a year ago he almost OD by taking 30 pills a day. He quit for a little bit after that, then relapsed. He is now taking 10 pills a day.

I am just wondering, how long can this go on for? What could happen to his body through time? What could the future look like,say if he doesn’t OD? What can i do?

Ps, don’t say divorce. If it was just me, i would have left already, but we have a baby and i don’t want to break his family.