One thing I noticed: it sounds like you're thinking in terms of the two most extreme decisions (stay "here" forever vs. "leave" your family to move to the city). You might be able to leverage your remote-work position to try different places, in case one of them might be a good fit for you.
Sublet an apartment or stay in a long-term AirBnB in a city that you're considering, and during that time (a couple of months, maybe?) dedicate significant energy to meeting people. If it doesn't work, then you have a better grasp on the reality of the situation - if it does, then you can extend your experiment from months to year(s).
you should take a backpacking holiday in a busy city somewhere (overseas?). If you have fun, try a working-holiday in a new city for a couple weeks. Maybe one you've been thinking of moving to?
just try it on. There's no downside.
I absolutely hate traveling, I just want to live somewhere and for it to become home.
You're probably right about the cutting off legs part, though I've simply lost sight of an exit from my current situation. I own a house, I have responsibilities, and I'm burnt out from work. I actually had a plan in place to move before I burnt out, but that fucked up everything.
All the best
I believe in your ability to make a better life for yourself.
You can do this.
I've seriously considered moving to a city, but then I'll have to lose the tiny bit of social interaction I actually do have, my family. In some ways I want to believe I could build a better social life in a city and be happier since there's more opportunity on all fronts, but I don't actually believe that would be the case.
I've never even met my coworkers, my social life is non-existent. It's actually crazy to think it's even possible to end up in a situation like I have.
The loneliness has seriously messed with me mentally at this point and I really can't see things getting better anywhere I am. I'm not sure I could muster the will to move at this point anyway. I think I may be too far gone.
I don't have a fix for you, but I completely get where you're coming from.