What does the long tail look like?

It might look like this: Most popular on Wikipedia

The most popular article on Wikipedia is the article about… wikipedia.

Not to mention dozens of articles about off-color topics.

Something really important is happening with long tail content, but the short head (the big hits at the top) is pretty scary sometimes.