I too struggle with trying to sleep due to back pain. I had a spinal fusion in 2012 at the age of 62, (I turned 63 in the hospital!), due to scoliosis. I have 2 rods and 20 screws in my back.
I won't take any type of sleeping pills due to the serious side effects. I also keep a heating pad plugged in next to my bed so that when I wake up, I can just turn it on & change positions. I take a cannabis gummy every night, which my pain doc is aware of & doesn't mind.
It's a matter of having multiple items in your "tool box" that you can use depending on what type of pain you are having. I sometimes use a rub in balm (Charlotte's Web). After being in pain for over 40 yrs, I have tried to keep various items handy that might help me. Unfortunately, there are days/nights, when nothing helps & I just suffer.....good luck to you.