As someone who works at a tech company and hires people, the key thing is motivation and passion for stuff. I see that you say you have no motivation and that is the only thing you really need to work on. Some of my most valuable people are not technically gifted - but they care about the product and work hard.
There's always hope. You could get some Python - perhaps start going through some Coursera courses (to show that you're actively learning, and will help reestablish your confidence - I've seen people quote numerous on-line courses and it's always a major plus) and try to get even a low-level job at a tech company, then work your way up. I regularly see manual QA people move to test automation, then move to working directly on products.
Even if you don't get a job at a 'tech' company, there is some sort of tech at all companies - and it's more important to be working in a field that you like and transfer to a more interesting company than to be coming from gig work.