I think it is a common curse of power

In the Bible, many good kings and even prophets did a terrible job with their kids. David is probably most famous, one son raped his half sister, but David didn't know what to do with it, just left it alone, so the girl's full brother killed the rapist half brother.

Lots of people get too committed to work, sure, but when you are in a position where many other people's livelihoods depend on you, it is more difficult to just walk away to spend time with the kids. Maybe Musk doesn't think like this, but I know guys who do, who think about all their employees families who will be ruined if the company hits hard times.

Similar thing with some pastors I know, everyone wants them to come and do some thing for them and their family, or go schedule time for advice on deep things, and in the hustle they don't get the time with the family they need.

TL;DR It isn't good that he is a workaholic, but when thousands depend on your decisions being good to keep their jobs, it is more difficult to drop work.