I do wonder how much of the backlash against agile is driven by people who never experienced waterfall
Another common pitfall seems to be engineering teams choosing agile when the business engagement model is waterfall. This puts you in the unfortunate situation of trying to change requirements without being able to get paid for those changes.
A nuclear power station built successfully using an Agile process would be something I'd like to read about.