People are cutting the cord because TV has gotten too expensive, not because "we're paying for shit we don't want" - people were paying for shit they didn't want in the 90's, but it was OK because the cost was reasonable. This is a cost problem, not a content problem. The channels you don't want are probably charging you less than $0.75 per month, in many cases probably less than $0.30 per month. Fewer bundles mean sports fans will start bearing more of the burden of the cable bill, because non sports fans will probably get rid of it, and the networks won't take less money, so they'll just charge more. But we won't stop watching sports, we'll just have to pay more to watch them. This is probably the way it should be anyway, I'd agree with that, non-sports fans have been subsidizing sports fan's viewing for a long time.
If you go purely ala carte (channel by channel), everyone ends up paying more and getting less content, it's why some form of bundling makes sense. The current base bundles have gotten too large and overhead costs (i.e. Rob Lowe commercials) have gotten too high, it's why streaming services will continue to become more popular. With streaming TV you're using existing infrastructure/hardware to watch television rather than paying for an entirely different set of hardware for just TV, cutting out the TV provider overhead reduces the cost of the service.
All the channel providers are going to work together to preserve some degree of bundling because they benefit from it (and as consumers, we do too, or at least sports fans have). It's the reason ESPN's plus bundle ($5 per month) still holds back everything valuable - "Sure, we'll let you subscribe to ESPN+, but you don't get to see any good college football and no NFL games". I imagine what eventually happens is that there will be a sports "basic" tier that will include both ESPN/FOX, it will cost the same as it does now, but after cutting out the TV provider (i.e. Dish/DirecTV) it becomes much more affordable and everyone is a lot happier