There are tons of examples of it:
- music, as the author points out. Kpop popularity in the west is probably a big example, but also artists getting famous on SoundCloud.
- video games are another place where there are a ton of indie studios doing their thing. The other day there was a post about Zachtronics.
- Books, we've seen several self publishing success stories on Kindle and others. Amazon claims more and more people are making over $50K on KDP.
- products, we see tons of success on Kickstarter and similar places. Pebble or Remarkable are two examples that come to mind.
My take, maybe counter to the author, is that the long tail is there but it's huge, but any individual thing - product, game, etc - seems small, unless it's a hit in which case it's not the tail anymore.