One of the hardest habits to kick bar none. Your sister needs to honestly think about getting out while the getting is good. She’s entitled to a decent less stressful life.
Threats don’t work. He has to want to get and stay sober. That’s up to him.
Believe me, I’ve been there with an alcoholic girlfriend.
Sister-in-law. She did, a few times.