I think Zuck has a fantastic understanding of systems and where they're headed...and a negative understanding of human motivation and emotion (outside of their quantified metrics). That's why he's smart enough to understand that FB as a platform has a limited lifespan and to get WA and Insta under his belt when they threatened him, and to know that he needs to come up with something else if he wants to continue to accrue wealth and influence. But at the same time, I think his Achilles' Heel is people acting like the irrational apes we are: If you push someone to hate you enough, they will absolutely cut off their nose to spite you, and this works at the cultural level as well. FB as a brand is culturally 'out' now.
Or, as a kid who played Civ online at the same time he did, I'd describe him as somebody who could win every game of Civ through bug exploits and memorizing the mechanics, but is such a dick about it nobody wants to play with him again and that confuses him.
"If you build it, they will come." Only if they don't hate you, and Zuck isn't doing well in the court of public opinion.