Think of a choice of career as belonging to a larger category of jobs that you find interesting. You might not be able to do every kind of the same type of job, but you can definitely find something that you enjoy and enjoy a lot. You just need to be mindful of your limitations. I'm not discouraging you from having your dream career. Instead, I am merely suggesting that you look at jobs as belonging to fields and that you should pick a suitable job in the field that you enjoy the most.
For example, say you want a job in health care. You might not be able to handle the strains of a doctor, but you may be able to run the machines that a doctor uses for their diagnoses. Another possible job is working in the laboratory, dealing with blood samples and so on.
Another example would be working in business. Perhaps the most stressful positions are not good for you, like being a high ranking administrator. But there are plenty of other job opportunities in the field. You may not be calling all the shots, however, that doesn't mean that you still can't have a very important position and even one that controls a lot of people.
Yet another example would be a job in education. Being an elementary school teacher could prove to be overwhelming because of having to deal with young children. Even middle school and high school may be too stressful, because you're still dealing with young people. However, you could have an important position at a college or university. Maybe kids are beyond you, but adults are not.
Basically, I feel that people with disabilities can succeed, as long as they understand that some things may just be too much for them. Afterall, autism includes social difficulties. However, I really do stress that there is no reason why you cannot have your dream career. You just may have to settle for something that is not exactly what you want.