My dad used to do the same thing, and I felt the same way as you that if it continued, a care home would have to be considered. To me it felt like a kind of torture, with no peace 24 hours a day, and feeling totally exhausted all the time, and yet still having to cope with everything.
Fortunately in my dad's case, sleeping pills have been very successful for well over a year now. He takes Zopiclone, and they can be prescribed from 3.75mg up to 15mg, and through trying them a suitable dose can be found. I think it's normal to start on the low dose, but the low dose made little difference to my dad. I know some people don't agree with taking these as it's thought that sometimes they can be addictive, but I think that is the last of my dad's problems with AD at 87years old. There can also be the fear of a fall being more likely, but I can only say that has not happened with my dad. Some GPs are wary of prescribing them I think. The CPN arranged for my dad's tablets by writing to the GP.
I sincerely hope you can get it sorted out, I know how awful it is. x