Sorry you are going through this.
My husband had exactly the same problem with back pain and not sleeping . He tried different pain and sleeping prescriptions and even CBD with no results. Finally he tried acupuncture and it has been wonderful . Gradually has gone to no pain. I really hope you can try this and it works for you too .