Agile projects can still fail obviously, but when they do they tend to fail in smaller ways (eg 4 weeks late instead of 6 months late, or almost hit the requirements instead of completely missed). That's a massive win.
And in the process, you burn out your devs, and have constant churn. How late are things happening in the long term, because teams prioritize the Agile rituals over cultivating long term technical excellence, craftsmanship, and team satisfaction? The way many teams practice Agile has a huge opportunity cost that's very difficult to measure, but still real.