It seems a bit arbitrary. We've seen most all ST captains screw up in ways that should prevent them from ever having command again. Picard lost the Stargazer, Riker lost the Enterprise to an outdated Klingon ship, all the captains have violated direct orders for a dramatic plot point. But they all end up back in the captain's chair anyway.
Yet somehow Worf's Change of Heart or other mistakes are the ones that will cost his career? What about Picard's Insurrection? Kirk's stealing the Enterprise? They all took actions that should cost them, but only Worf will suffer the lasting consequences?