OP, I spent over 30 years as a software developer (ending up in the security area - as an aside, this is no more lone-wolf than anything else, in fact, less so, as there are a lot of awkward conversations with stressed customers...).
I am not the most socially adept person either.
One thing I learned over the years, through bitter experience, was, if a discussion doesn't seem to be going anywhere, take a step back and get everyone to lay out their case from the very start.
99% of times, there is a fact that not everyone was aware of, or that people are rating at very different levels of importance. Once that is found and highlighted, the discussion can get moving again to go find a solution. Happy days.
So. You said yourself you're not particularly keen on being a programmer. So forget about why your brief attempts have not gone well. It's not as if it was your life's dream anyway!
Time to take that step back and look at the big picture...
You want a job, one where you can apply yourself, progress, make money. You hoped that, if you did the training you did, that programming would be that job, but you do know now that you were misinformed.
So, the real question is not about "why would someone in academia say something that wasn't true"(¡) or, "why did I get hired and fired?" (+)
the real question is,
"With my background and skills and aptitudes, what line of work should I be considering?"
My advice: start a new thread, lay out your education, work, and other history, what you find natural and what you really don't, and ask for opinions. You'll get more useful info there than from careers advisors, because the people on MN have actually done these jobs, whereas careers advisors have just, well, been careers advisors! And experience is the best teacher.
¡ because academics don't always know that much about the outside world, not to mention that like many humans, they fib or big things up. Sad but true. They want to make their course sound worthwhile - whether or not it actually is.
** Covered extensively already!