It's shit, OP, I get it. I have a lengthy and sorry tale of my terrible back, which ended up in 4 surgeries over a 12 year period (x2 microdiscectomies at L4/L5 & L5/S1; a spinal fusion at both levels; and then a revision because of a very quick re-herniation.) The surgeries were because I had foot drop, and then cauda equina - both of these should have been advised to you as red flag alert symptoms.
I would say that, from my experience, don't let a chiro touch your back. They are largely ungoverned, and you can get terrible, as well as great, ones. My advice would be to find a really good physio, with specialist experience in back injuries. Things which have helped my maintenance have been getting, and keeping, a really strong core - so Pilates, regular physio, and things like swimming. I've also had a series of nerve root injections - privately, and on the NHS. Privately, they were about £1900 each (I know!!) because they're guided under a contrast nerve scanner. However, I went on to have almost the same on the NHS, in slightly less luxurious surroundings, and with dodgier coloured gowns. 😂
As others have said, it's worth waiting to see if it does resolve, with really conservative treatment, like the above, before looking to injections and surgeries. If you do end up having to go that way, see a neurosurgeon. One of the best pieces of advice I got from a surgeon friend was not to let an orthopedic surgeon do this stuff. They can be great - but more often than not, they're not doing enough of them.
Anyway. If I had £800, I'd be finding a really good physio, and getting 1/2 a dozen sessions with them - and then some 1:1 Pilates to get that moving. In the meantime, be really aware of the red flag symptoms (numbness in your saddle, inability to control bladder/bowels, and loss of power in the leg/foot.) Also, get your GP to get you on some good nerve painkillers. Here, in Scotland, where I am, the protocol is Amitriptyline first (no effect for me), then Gabapentin (I was loopy for weeks on it), then Pregabalin (takes the edge off, and no horrific side effects for me.) I'm still on Pregabalin, as I ended up with permanent nerve damage, and chronic pain. My biggest regret was leaving it too long before getting real help - and not paying for a private MRI, instead of waiting 9 months for an NHS one (I was too functional, apparently....)
Take care, rubbish backs are shit.