Maybe but you can pretty much guarantee that your sports fanatic is going to end up paying a lot more to watch games. If the ESPN cable model dies your going to end up paying espn to watch these games online, what that cost will be up to what people are willing to pay but I would bet its going to be more than the 6 dollars a month it cost currently with cable.
Also the person who doesn't watch sports maybe likes to watch HGTV. HGTV is subsidized by sports fanatics as well since they are paying say 1 dollar month for a channel they will never watch. Whats going to happen is some of these channels will die off. They won't make it, the ones that do will have to be able to charge more for their private channel. So instead of the current 1 dollar they will charge 5 dollars. What could end up happening is the industry will move away from the cable model and the consumer will end up paying similar money to what they do now but without as many channels. I think more likely you will end up bundling through someone like sling. Consumers will end up paying similar amounts to what they do currently its just the provider won't be cable/satellite it will be a online company(probably the same company just through a different access)
This. No one ever talks about this. And the sports fanatics will be paying the most IMO. I'd probably pay because I love sports, but they are going to get their money somewhere. We'll be paying say $25 for ESPN instead of $6 (I'm making that number up), and like you said, people that want to watch TV w/o sports will probably be paying more for their channels, or they will just go away.
Time will tell, but what is cheap now won't be in the future once that is the way to generate higher revenue. Right now is a transition time.