I haven't read the article because TLDR; but agile, particularly in it's earlier incarnations like XP is the least bad methodology I've used for most of the problems I've worked on in non-tech firms and small tech firms. I never worked in a FAANG or a Microsoft so at that scale things may be different.

The usual rules apply, there is no silver bullet, nothing is all bad. Pick the most sensible process for the job and adapt as necessary.