There is a lot that you can do to learn these skills and succeed in organizational roles. It’s different to be a CEO where the job is primarily politics and face to face discussion, and being a VP where you just need to make your org work.

I think with Musk/zuckerberg/gates you are seeing a giradian duality. They simultaneously appear charismatic and awkward. It’s either extremely context sensitive or you are unable to accurately perceive it.