With a back condition and being used to the creature comforts of office/home based working, are you sure you'd want to step into HGV driving, long stints of driving, unsocial hours, pressure to get deliveries no matter what the road conditions and using Motorway services for food/showering etc. I'm not saying don't think about it, but I couldn't imagine myself going from doing SQL to being a lorry driver, it's a massive shift. I also note your comments on Autism, whilst you may find that there are less people to have to converse with and that suits you, you might find the banter among the drivers difficult to contend with as well. This is coming from someone who enjoys the isolation that working from home and Covid has brought me. If you're not comfortable with all the strangers that being a bus driver would bring, then imagine driving a couple of hundred miles to deliver something and having to deal with people you've never met whilst loading/unloading, then driving another 200 miles and seeing more strangers.
Have you considered shifting to SQL, that's what I did back in 2002 never looked back and MS Office is like another alien world to me now.