I don't see how a social media site and an automobile company have much in common.
It's quite possible that Musk is better at some things than he is at other things. Engineering and manufacturing are quite different from maintaining a large social media company, the skills don't translate.
Another major difference is that Musk built Tesla up from a small size, so it was always structured according to his style and expectations of management, whereas he bought Twitter as an already-large company with an established corporate culture that didn't match what he would have done. That's the first time he's bought such a large pre-existing company, as far as I'm aware, and he's having huge problems "reshaping" it.