If he hasn’t tried already and he can’t afford a therapist here’s the contact for the National Alliance on Mental Illness (NAMI) HelpLine: Call 1-800-950-6264, chat, text "Friend" to 62640, or email helpline@nami.org.
As long as he is dealing with depression and a drinking problem, nothing else will make him happy. He needs to address those problems first.
Moving states is really far and a big move for sure. Have you both talked about compromising, that way you dont lose your family support system but maybe just move right outside of the city so he can be in some countryside. I was in a relationship where i lived with the guy in the city and i became really depressed. I came to realize i really missed the trees and the just living somewhere that wasnt so cluttered with people and houses. Would you be willing to move out of the city if you could reamain close?
did he try seeing a therapist? it really helped me.