Ask him if he wants you to stay for him, to rebuild your marriage, or if he doesn't. An addiction separation isn't the typical one, is it?
Or, ask yourself that. What do you want more...him or the transfer? Unless he's coming with you, what's the chances that you'll recover living in different states? Could you delay the transfer?