Hello treevoice: I'm sorry your hubby is having such a difficult time. It's so difficult to keep going when one is exhausted.

Actually, as it happens, I had one of "those nights" last night... so I'm pretty-much exhausted today too.

I don't know as I have any great ideas for you here. Currently what I do, when I can't sleep, is to get up & do walking meditation. I'll walk slowly around-&-around our dark & quiet home for anywhere from a half hour to a couple of hours or more. Typically, when I go back to bed, I am able to get to sleep. (I should have done this last night, & I finally did. But before I did, I laid in bed awake, thoughts racing through my brain like stock cars... for a couple of hours! I think I can be a bit manic sometimes...)
Quite a few years ago, when I was on psych med's, I had difficulty sleeping. Back then, I was prescribed Trazadone for sleep. It's an old antidepressant that's not much prescribed anymore. But, at least at the time I took it, it was still being prescribed to induce sleep. By the way, I have also tried Melatonin. I found that, if I was going to be able to fall asleep, I didn't need the Melatonin. And, if I wasn't going to be able to sleep, the Melatonin didn't help. Plus it always made me groggy the next day...