One thing the article brings up is that "success" may not be synonymous with "financial success". If you have a specific burning vision for a thing that should exist in the world, it might not be the most profitable thing, and the founder staying on is probably a good way for exactly that product to exist - but an outside CEO might choose to compromise the product vision and significantly expand the potential market in doing so.
I suspect involuntary founder replacement is much more common in venture-funded companies. While your, my, and the founder's definitions of success may not be synonymous with "financial success", many VCs and their LPs may not feel the same. Obviously it's tricky to fully generalize, but the point is that VC can be expensive if founder and investor motivations aren't closely aligned.
https://hbr.org/2008/02/the-founders-dilemma