Sounds like you have been together for a long time, through some difficult times as well. I think continuing to drink has a much better shot of destroying the relationship than space will. Sounds like your guy needs a break from all the drama and drinking related issues.
True, you won't read much about happy drinking here-that ship has sailed for most a lonnnnng time ago. Reading here will let you know you're not alone, ways others have coped, new ways to deal with problems without running to booze,etc.
The sleep thing may take awhile, but once it does, you'll finally wake up refreshed. Hang in there!