All those questionable examples and not one mention of search engines? I'd argue that search engines are a much much bigger threat to URLs than all of the author's examples combined. (You don't need to know a URL if you can just search for the site name!) But it's also a counter-example: search engines haven't killed the URL yet, so I doubt any of those other examples will.
Good point. While I provided a bunch of examples, I didn't exhaust the number of examples of this trend. Search is another, and so are mobile experiences (beyond the App Store).
At least with search there's a degree of "infinite" in the results. Of course, the results are defined by SEO and robots.txt files, and so aren't as egalitarian as URLs, but search engines are another example of the increasing minimization of URLs in interfaces.
