This may end up being a wise choice for the company (I think Ev is happier now), but you don't have to be a detail-oriented leader to be a great CEO. You just have to be great at finding people who complement your strengths and weaknesses as a leader.
There is no perfect CEO, so Ev's situation shouldn't apply to everyone. Zuck kept power as CEO and has done an extraordinary job. Larry and Sergey created a triumvirate for the big decisions, and that's worked out quite well as well.
So looking at this from a scientific perspective, essentially anybody can be a CEO (memories of that classic Dan Ackroyd/Eddie Murphy movie "Trading Places" comes to mind).
Scientifically any theory about Zuck doing an "extraordinary job" is non-falsifiable.
Why then should we read the innumerable puff pieces about why one person should be CEO and another person COO?
There is no perfect CEO, so Ev's situation shouldn't apply to everyone. Zuck kept power as CEO and has done an extraordinary job. Larry and Sergey created a triumvirate for the big decisions, and that's worked out quite well as well.