This is only the tip of the iceberg. His disease is a progressive one, one that has no cure.
He will be an addict all his life, it is only a matter of whether he is clean and working a strong recovery program...that's it.
Personally, I'd listen to your family and friends, they are not wearing rose colored glasses and are thinking with their head not their heart.
Read all the stickies at the top of this forum, it may help you to understand this disease and the rollercoaster ride you will be on if you stay with him.