Well, no. They are not at all alike. Stephen Wolfram has a lot more _people skills_ than Sheldon Cooper. Sheldon Cooper is the stereotype of the Asperger scientist who succeeds despite his inability to interact with people, while Stephen Wolfram has been at the helm of a tech company for 30+ years, and that's not something you can really do without having to interact with other people.
I suspect Wolfram also succeeds despite the nature of his people skills. I found this letter from Feynmann[1] to be an interesting and early read on his behavior.
Wolfram invented v1 of Mathematica, and founded a company to sell it to technical users. It takes minimal people skills to hire people and to sell a technically good product.