Is it normal for me to believe i will magically do well in such a career?

I'm in my late twenties, a high functioning autist, and extremely confused about choosing a career because I have not made any progress with social skills since my early teens. I work in the health field, and I feel that it's extremely unlikely that at this age I will suddenly start developing social skills and leadership that I have always lacked. Working in any clinical setting depends on a lot of social networking, and training depends a lot on being in your seniors' good books, which I've always failed at because people generally find my naivety extremely annoying. My experience working in clinical settings was extremely unpleasant because of this. I was also unable to create a social network. At one point I was isolated and mobbed for a couple months because I was perceived as extremely vulnerable. That was when I finally broke and quit my job. I had been in so much stress that I had developed chronic fatigue syndrome. I had always dreamt of training in a clinical field but now I feel it would be an unwise decision, even though the other option available also makes me extremely depressed: training in a laboratory field, with no patient interaction. I don't understand what I should do. Hope is a weird thing. It makes me feel that I'll magically acquire the power to do well among people. Do you think it's possible?