Thanks everyone. I tried propping myself on an incline last night so I had another option for a sleep position lying on my back but sort of upright and that actually helped as I could give my hips a rest for a couple of hours.

I think I might look into seeing a physio/chiro to see if my hips need to be realigned or something.

Otherwise, I've just got to suck it up and hold on to the fact that this won't last for ever