Some people have an attitude to work resembling “I spend most of my day here, so having enjoyable professional relationships with my coworkers is a major determinant of my quality of life.” And there are other people who have an attitude closer to “it’s my goal to deliver value efficiently and get paid. I’m not here to make friends. Any meaningful human interactions happen outside of work.”
I don’t know enough about autism to know if that’s the right label for the second category. (I’ve had coworkers who identified as autistic who seemed to deeply care about whether I enjoyed working with them.) I think these two types of people can work together productively, but I don’t think they’ll ever totally understand each other.