As a social worker yourself, what do you see when you take a step back and look at the big picture? all the answers you seek are actually in your own post.
don't let anyone but you be in charge of your self-worth.
when someone no longer chooses to be with us, communicate us, interact with us, it's best to accept that and move on.
he's doing what addicts do. he doesn't share YOUR vision of what HIS life should look like, he has his own. to which he is fully entitled.
it is most concerning that you mention your own fragile state, depression and suicidality. THAT is what you should now be focused on and fully committed to. get back to you. regain your own sense of worth and purpose, that is not in any way dependent upon another human being. work on your own recovery now.