> history has shown
It doesn't really show that, though. Putin was not stopped by term limits. Hitler seized power within a year of being elected. Lukashenko established his rigged state within two years. Fujimori launched a self-coup within two years. I'm actually not aware of evidence that term limits have ever meaningfully did anything to impede a would-be wrongdoer.
Survivorship bias explains that. The list of dictators-for-life does not include those who don't become dictators for life.
I'd suggest that term limits are party of a package that rests on strong public faith in democratic institutions. E.g. Macron is about able to hang on, but i doubt he could stay past an electoral defeat because he presides over a nation that won't tolerate it.