I think you hit the nail on the head- you can’t plan a future with him. If anything, your confidence and self esteem will just be more and more eroded over time. It’s a kind of emotional blackmail when you are used as an excuse for their relapse. It sounds like you are a “carer” type person(I am too) but don’t make this man your project. Please put yourself first.
