> Surely there should be enough content that it's more than a tiny minority which succeeds?

Isn't this what has always happened historically with any new media platform, from print to radio to online? Storage space got cheaper, but human attention remains limited, so popularity and feedback loops are a human problem, not a technical one.