"Agile transformations" are bad, but I still think agile itself is fine. Teams of self-organized, competent developers tend naturally toward agile-like practices. I've seen agile's story-centric model of development help new developers grow by giving them responsibility for specific, testable units of work.
As a lot of people have already said, the problems arise when managers expect agile to give them software on a timeline.
As a lot of people have already said, the problems arise when managers expect agile to give them software on a timeline.