It sounds as if the 2 of you work well together.
Are you entitled to any funding for care? I would either use this, or consider paying privately for care so that you can have a break.
Do you have a spare room where you could sleep comfortably, whilst the carer sits in the living room (summoned by a monitor)? I know some agencies provide carers who work from home or an office and simply come when summoned, although I think the geography / travelling time might be an issue.
I have a neighbour who simply goes away for a week twice a year. She pays for carers to come and stay whilst she is away. Her DH is very sensible & understanding - he doesn't enjoy those weeks, but says his contribution is to understand the necessity and not fuss.
I think it very individual as to whether you would prefer an unbroken night every week or two, or a block of time away.
I also know some carers who find that getting one unbroken night just makes it harder to get back into routine, so prefer to look after themselves in some other way. But I do think that you need something to help you cope, otherwise DH will have to mange without you!