As addon dev, this is completely false. Wow Lua had coroutines support in patch 2.11 so it can run in parallel.
Moreover it vastly depends on how addons were written plus how many events they are listening to.
Also you can measure how much CPU are addons using with addon called "Addon CPU Usage".
For example addons like Damage Meters will be almost always cpu intense (well, compared to other addons at least) because they listen to COMBAT_LOG_EVENT_UNFILTERED which happens pretty often
Good addons can relinquish events after finishing tasks so it just sit in memory.
Blizzard Interface code are addons too. And fun fact, they are not really fast, their code is mediocre and runs fast simply because they offer little functionality.
Overall addons are not really an issue.
https://www.mmo-champion.com/threads...ts-your-result
Considering usual test time in CPU Addon Usage is around 120s, taking 0.2s of that time means this partical addon slows your WoW by around 0.16% (around one promile, not even a percent)