My thoughts screamed manipulation when I read that message that he sent you. There is nothing about how you feel. There is nothing about how great you are. It's all about him. This is textbook alcoholic manipulation. He's guilt tripping you to stay. He says he needs you, but gives no steps as to what he is going to do for himself. He almost makes it sound as if he "needs" you to hold him up like a crutch. It's a draining weight on your shoulders to make yourself responsible for not only yourself, but also a destructive individual that needs you to clean his messes and pick him after he falls.
You can love him and support him from afar. My advice would be to not get yourself entangled in the chaos.