I'v gone through this myself, still do quite a bit.

Get him in to get some help, it might take time but it really does help.

Given that he is suffering from a sleep disorder as a result they will probably put him on some meds to help him sleep. I am on anti-psychotics (quetiapine/saraquel) just so I can sleep at night. It isn't fun to have to take pills for it but getting some decent sleep is certainly worth it.

Oh, they didn't start me out on that, it took a year of going through every other medication they could think of, including tranquilizers just to find something that worked well enough without horrible side effects or addiction.

Anyway, they can help you guys, you just need to get him into treatment and keep him sticking with it. It really will help in the long run.