I herniated my L2, L3 vertebrae 3 years ago. It sent searing pain down my lower back and into the most sensitive area of the male anatomy. Not fun. Fortunately, physical therapy made the pain go away. If your back doesn't get better I recommend looking into PT.
After PT I kept my back in shape with yoga, but stopped during the pandemic lockdown and the pain came back. Working out at the gym since then has healed the pain, but I have to be super careful about form, especially with leg and back exercises. If you aren't going to be hyper focused on weight lifting form, yoga is probably the better bet.
Just my opinion... Good luck with your back pain.