Have you tried physical therapy? An orthopedist can diagnose you and refer you.
I thought I had a back issue developing, but no prescrips helped. Turned out to be my hip, not my lower back. I remember before that not sleeping well and had a tendency to sit up in my sleep, slightly awake, then falling asleep again. That time I fell out of bed LOL. Landed sitting up, but down on my right hipbone first, pretty sure that caused it.
The problem is around the cartilage where the hip joins your spine. Went to physical therapy and a few exercises later it was fine. I still have to do them from time to time, but it’s not bad and never remotely to the point I can’t get out of bed like before. I lived with that crap for a year before finally addressing it. Apparently it’s pretty common.
PT can do some amazing things. I also use a TENS device sometimes. They’re cheap and also good for sore muscles.