Cable Television, as we perceive it today, is in a steady decline (I'd cite something; but even the most cursory Google search will turn up dozens of articles confirming). While I recognize your concern about the cable company ownership and DRM, I believe that over-the-top services like Sling or DirecTV Now in conjunction with Netflix and Amazon are far bigger threat to Tivo and the like than anything the cable companies themselves can do.
And that makes it the biggest threat to Netflix when net neutrality (and particularly the specific prohibition on ISPs favoring their own video services) is killed by the new leadership at the FCC.
You're inferring that they're related, but I see them as orthogonal.
I'll take your word that it's poorly implemented. From my POV it just works—my two experiences are with a TiVo and an HDHomeRun (first with Media Center, now with Plex's beta DVR feature), and in both cases use has been uneventful.
That people don't know it exists doesn't surprise me, since the cable industry has always fought this FCC-required concession to consumer choice. If anything, it strikes me that cable was highly motivated to ensure CableCard's failure.
I don't have any love for CableCard, but I'll be sad when it goes because it'll mean that kind of interop is gone forever.
I recall someone saying that technicians would bring a basket of CableCards and hope one of them would work.
Mostly though cable crypto is dominated by two companies who provide the head end equipment and who for a long time provided all the settop boxes - they didn't want to lose that lockin so while they were mandated to provide cable cards they weren't all that happy about it