Man, there's hope. I'm proof of that. You do have to keep plugging away at it, though. I spent 25 years as a missionary/professor (and was considered an excellent professor at that). I was fired by the denomination 15 years ago, but that was because they found out I was gay, not that I was Aspergian (which even I didn't know back then).
After I was fired, I graduated from library school. Largely because of my age (mid 50s) it was hard for me to get my first library job, but I ended up working 10 years as a cataloger, which is the perfect job for someone with OCD and Asperger's. It was while I was a librarian that I learned about Asperger's, and helped me realize several aspects about my personality that I had always wondered about. I've never been professionally diagnosed as Aspergian, but I did take the self-test on this site, and it confirmed what I've accepted about myself for about five years now.
I retired two years ago. Once again, I'm feeling frustrated. I'd like to get part time work as a librarian to supplement my barely-adequate income. But in spite of applying for over 15 library jobs, I haven't gotten anything. But I attribute that to my age, even though age-discrimination is supposed to be illegal.