Sunday Ticket is exactly the type of service that should be an extra fee rather than part of a general package. Most people - even most sports fans - don't need to be able to watch every NFL game. I think the main flaw was that it's just been too expensive. Compare the amount of content you get with MLB.TV or NHL.TV (or whatever name you wanna give it) vs. what you get with the NFL package and then look at the prices.
The only people I know who ever got Sunday Ticket were folks who wanted to see their team, but lived well out of market (A Bills fan in Arizona, and a Bengals fan in eastern PA).
Yes, anecdotal evidence. But most NFL fans I know pretty much watch their team’s game, Sunday night, Monday night, and a whole lotta RedZone.
Disney is already down the extra charge path, with movies on Disney+ and UFC on ESPN+. If Disney gets the package, I am sure it’ll be an add-on price.