Sorry, those were meant to be examples, not an exhaustive list.
I think the opposite. Most serious sites will never need sharding.
I think your definition is better, and I should've said "a potentially-large site" or something like that.
Every large site on the internet has talked about strategies around sharding. At some point you are surely going to hit the physical limitations of one database on one server.