Agile & Waterfall are two sides of the exact same Coin, and are equally good or bad.
Agile enthusiasts enjoy lambasting waterfall while espousing “Agile”, however the two techniques are exactly the same.
“Waterfall” is basically a Strategic method of attaining goals, and “Agile” is basically a Tactical method for achieving goals.
Both are equally limited; strategy without tactics is ineffective, and tactics without strategy are especially ineffective, especially over a longer term.