Moving to Denver last year was an opportunity to "cut the cord". Over-the-air is mostly fine here with an amplified indoor antenna. (More about that later in this post.) But we still wanted DVR capability. I tried getting that with a combination tuner-recording device ordered from some outfit in southern California whose name I've already forgotten. The tuner was excellent. Problem was, that vendor was using a generic remote control that wasn't properly programmed. Buttons that should have worked didn't work. Labeling on the remote control did not match the instructions. It was impossible to actually program the thing to record. The vendor sent me another unit; same problem. The vendor sent me another remote control; same problem. I can usually get anything to work, but this vendor's device, particularly the remote control, totally stumped me.
Finally, I gave up. We now have YouTube TV going into a Roku. Essentially, we're using YTTV as a cloud DVR. $73 a month may seem expensive for that purpose. But we're paying $70 for 1 GB fiber Internet. Combined, this is a little over 60% of the cost that we were paying Comcast in Oakland, and with way better reliability. As a bonus, I can watch YTTV on my iPad, which has been useful very recently as I recover from surgery and have mobility issues (which should go away in a few weeks). And we get the cable channels that we are interested in, which aren't many. We're not much of a TV-watching household, to be honest. We may end up with Netflix eventually since we were using its ancestral DVD service for years but there's no haste to do so now.
As for over-the-air: two of the major network affiliates, KMGH and KUSA, made the bad decision to stick with VHF for RF. Tegna at least has KTVD to work with as well, putting KUSA's programming on KTVD's RF at virtual channel 9.4. Scripps doesn't seem to have a better option for KMGH, though. Lookout Mountain is not as great of a transmitter site as one would think; reliable VHF reception in east Denver pretty much requires an amplified antenna, and even UHF LDs/LPs need amplification. (FM translators on Lookout are also feeble here.)
Conclusion? Linear probably will dwindle for some time but won't go away altogether. Cable companies screwed their own pooch by tacking on fee after fee after fee, inflating their monthly bills, and not working to contain costs, thus encouraging people to find other choices. Thus, viewers are finding lower-cost options that better satisfy what they want. Over-the-air can work, but circumstances vary and may require some tinkering. Cable providers will primarily become Internet providers, but will need to learn how to run more reliable networks as DOCSIS feels like a gigantic hack; with Comcast there was always some issue or another every month or so relating to a reconfiguration that the Comcast-approved modem couldn't handle.