Yeah, it's sort of like negative stability in EU; people have a huge and somewhat unreasonable aversion to it, but tyranny is just a number!
(It's a shame this wasn't introduced a couple expansions back, or the response would be "no, tyranny is a Way of Life")
Also, having just tried it, you can indeed defy the council vote even with Full Council Authority.