Much respect for your Dymph. I know how it feels when your social battery is always low. That goes for me, and also for my partner. I don't have a steady job because I can't handle it. That's something I always knew, tried anyway. There 'failed', and what we have now accepted. I have found other ways to 'create' my own job. My partner does have a steady job, but that's exactly why we hardly ever go out, we don't visit friends after work, we don't go out after work, and we hardly ever go out together on the weekends. Simply because he needs to recharge his batteries and have some free time to do his hobbies. He also says the same as you: "I don't have time". The only reason he keeps his job is that we need it financially. But a social life is completely lacking ... precisely because of that job.
And that you think you're a failure... Listen to @rubencress, you're not a failure. Everyone has their own and different qualities. I am convinced that your qualities, just like mine, do not lie in walking in the crowd with a 9 to 5 job. Doesn't matter, there are other options.
“No human ever became interesting by not failing. The more you fail and recover and improve, the better you are as a person. Ever meet someone who’s always had everything work out for them with zero struggle? They usually have the depth of a puddle. Or they don’t exist.” - Chris Hardwick