Everyone understands the real problem. The government prevents the owners from doing anything about it. The idea that the salaries are somehow the owner's fault is naive. They tried being reasonable and were found guilty of "collusion" without any evidence. They tried to lock out the players and were found guilty of "unfair labor practices" against a union that REFUSED to bargain about wages. How can a thing be a union if it refuses to bargain? There is nothing that can be done about it.
But, yes, the RSN problem is just the first chicken to come home to roost. Mainly due to incompetence at Sinclair (don't carry the RSN, no retransmission consent, not negotiable) and MLB (don't first pay for your local team, no access to out-of-market packages), but next will come the pure sports channels such as ESPN, FS1, etc. Then the sports specific channels (Golf, MLBN, NBATV, etc), and finally the general rerun channels that include a lot of sports (TNT, TBS, USA, etc).
There is no real solution. Selling sports either a particular sport or a channel, a la carte, is a non-starter. The amount needed to break even is way more than most people can afford. Including sports (not over-flows and out-of-markets, as on ESPN+, real primary contracts as with Apple and MLS) in general streaming has the same issue. Those looking to save money, which is the primary (only) streaming only customer will simply look to save money with non-sports-containing streamers.
Remember when there was a system where everyone paid a little towards a MOUNTAIN of content. Everyone had what they wanted. It worked. It protected the consumer.