It’s a tough situation, man.
I would say you very likely could find another position elsewhere fairly easily, but I do understand not wanting to leave your “work family”. At the same time, you shouldn’t ever have to light yourself on fire to keep other people warm.
At the end of the day, you just have to do what’s best for you (which is probably whatever keeps you sober most often, heh).