An MBA friend actaully asked the very same question in class

MBA course: Organizational Behavior and Leadership

Setup/question: If one's superior acted in such a way that s/he totally lost the respect of her/his subordinate(s), would it be in the best interest of the subordinate(s), or even arguably also in the best interest of the organization, for the subordinate(s) to revolt and seek the removal of the superior?

The "guru"'s answer: No, never.

Follow-up question: Could you please elaborate?

"Guru": No need. It is a cardinal sin to revolt against one's superior. Put in another way, it equates to career suicide, period.

Conclusion of discussion: A functional organization has proper established mechanisms to select/remove its leadership, and revolt/rebellion is not one of them.