It wasn't that short term - we had night carers for about 6 months. My mother was in pain (and had been for some years beforehand) but with her dementia she lost all her resilience to it. It was a very harrowing time. I think maybe once she had an airflow mattress and hospital bed it helped or her condition changed and she slept through the night better. I was still administering morphine to her and applying Fentanyl patches for the subsequent three years - I don't know how she went on so long with such strong painkillers.
I suppose the point is that, if the person's condition is extreme, you will get social services funding (up to a point) to help with the situation. In the last two years, she had CHC funding but this didn't affect the amount of help we got - she had the maximum of 4 double (2 carers) half-hour visits per day.
I think
@padmag should keep in mind that care at home is possible and you don't know how the illness will progress. Hopefully, padmag's partner will not experience any behavioural or mobility problems and the question won't arise. My mother's combination of symptoms (chronic pain and Alzheimer's) was unique.