From my MIL professor just yesterday, who is tenured and has been working at the same university for 30-35 years, "Tenure basically means that it's impossible to fire you."
But yes, getting tenure can be very difficult. She also spoke about how tough it can be for professors to get tenure. All it takes sometimes is the dean of the department or the university president to veto the vote of the rest of the board.