> if you have a project that is Very Important To Succeed, a team might be more likely to adopt waterfall

Yes, but that is directly in contrast with what Agile promises to do, namely helping teams to succeed.