Everything wrong with RSS in a nutshell: this is a problem real people don't have.
But I want to dig a little at this. I think the fact that most people only have access to CNN or Time or Fox News or Cosmopolitan or Maxim or whatever... that there is not an easy way for people to get news aggregated from 100's of their peers and thought leaders in their affinity groups.... I think that IS a problem people have. It may not be a problem they are aware of, but I think the social cost of consolidated media is very high.
I think RSS, and technologies like it (Twitter, Facebook) are an important part of the solution to that problem. RSS is obviously not very user friendly, and I'm not sure if it will have a place at the table 10 years from now.
But the problem it solves (a standard interchange format for syndication) is absolutely real, and it's not going away.
I know most people don't like to visit more than five sites on a regular basis, but the same could be said for printing bingo cards or reading books. I don't think that makes a significant portion of outliers "not real."
Also, anecdotally from being the de facto "computer support guy," I've found that more people don't know about RSS but would find it useful than those who know about RSS and can't imagine a use for it.
I bet if someone made a sports oriented RSS reader a whole lot of people would use it. Some people like going to <= 10 sites to see what's new but people who follow more than 10 sites would like the idea of RSS.
Difficulty reading "100 sites several times a day" isn't a technology problem; it's a focus problem.