Of course, it is a mistake to extrapolate the numbers about people dropping linear TV (and these are not reported, as the number that simply cord-switched from cable or satellite to a streaming linear service are not reported, but are certainly substantial) as some sort of trend.
Rather, a new choice was available, and those who want that choice, which, more than anything is to save $$ and do that because the do not like sports, which an outsized cost on linear TV. Those who want that choice have mostly all moved. We are very near to peak streaming.
The churn issue with streaming is also, certainly, a thing. The nature of the product makes it so that it is easy to go from one to the next to the next, Bingeing whatever you want and then moving on. It is the nature of the technology.
Sports (not ST, which is a different, automatically unprofitable, thing) are an attempt to work on this. So far, it is isn't working.
As to what alternative ESPN has, lots of people at Disney are working on that. Same at its imitators. As with any marketing question, there is not always an answer. ESPN can never sell the service a la carte. Doing so undoes all of its linear contracts. The price if ESPN were available a la carte to only those that want it (and, remember, most everyone who has gone streaming only, has done so because they do not want it, at least enough to overcome the pennies they are saving) would have to be huge. About $90 if you look at the ratings ESPN, and live sports more generally, gets and extrapolate that those are the people willing to pay as a fraction of the "everyone" who paid for it a few years ago. And that is just ESPN, you have to add in the Fox sports channels, the part time sports channels like TNT, TBS and USA, and the RSNs. We are looking at about $200/month just for sports. That won't work either.
Which, since it can never be sold a la carte, and those who do not wish to pay are no longer doing so, we are at the point where the bids for sports rights, and thus sports salaries, start to go down. Breaks my heart.
As to the unique thing that is ST, different rules apply. It is unprofitable on a cash basis, and will continue to be. The only question that remains is which of these two streamers will buy it and predicate access upon buying their general streamers, which many people, and most all public houses, have no use for.