What I'm antagonistic towards is console manufacturers selling incomplete games on their DRM boxes.
Nintendo's the good side of the curve? Nintendo shut down the 3ds and wii u eshops when the console was half a generation out of date. If we lived in a world with no piracy and no emulation (and no buying secondhand consoles with paid DLC installed, because that's against TOS), and I threw my PS4 and Wii U into a wood chipper, I'd be one used PS4 away from playing my digital or disc copy of Bloodborne complete with the Old Hunters DLC. I don't even have to buy it again because Sony is sane and ties purchases to an account instead of a console. Meanwhile on the Nintendo side, I'm never gonna play as Cloud in Smash 4 again, with or without my disc.
How about the situation where Nintendo and Sony both stop operating CDNs for old consoles? In that case, they're equal at worst - I can play stuff I have installed until the console breaks, same with discs/carts. If the console breaks post-CDN apocalypse, and I buy a new one that can't access game updates, I'm stuck with infinite loading screens in Bloodborne and whatever the heck v1.0 of Mario Kart 8 was. Rhythm Heaven Megamix was never released physically in the US, and the 3DS is region locked, so if you want to get your hands on that, up yours I guess. Wanna experience the weirdest port of The Binding of Isaac to ever exist? Nope.
Nintendo released a limited run digital purchase (Mario 3D All-Stars), for Christ's sake! What's MS or Sony done that's even close to that? Pulled a free trailer for a canceled horror game? I can still buy PS3 games on Sony's store if I want to. On the PlayStation 3! From 2006!
Nintendo, MS, and Sony do not deserve any grace when it comes to this topic. They're all bad. It's just easier to overlook how bad Nintendo's preservation of digital content (including significant portions of games that also got carts) is when it takes half an hour to hack a 3DS, Wii U, or launch model Switch.
Physical games aren't the whole game anymore and haven't been for over a decade, is the main thesis. A DRM-locked (encryption and copy protection on the cart/disc are also DRM) physical copy that needs DRM-locked downloads to be complete is equal in preservation weight to a DRM-locked fully digital game. Once both releases are DRM-locked and download-reliant, I do consider the DRM-locked download that's still acquirable 10 years later to be better than the one that isn't. Both are shit, but like you said - spectrum. Disregarding piracy, The Old Hunters is better preserved than Champion's Ballad (Wii U).
Meanwhile outside of console land, DRM-free digital exists. That's the holy grail gold standard, not 60% of pokemon sword on a flash drive. DRM-free digital survives the CDN end-of-lifing. It survives my PC exploding, because unlike even complete physical games like a SNES cart, I can copy my DRM-free digital installer to as many devices as I want. DRM-free digital installs the version of the game I downloaded, without any connection to the internet. DRM-free digital survives the music license for a David Bowie track expiring. Even if every physical console release eventually got the "final cut GOTY" disc with everything on it, it's worse than DRM-free digital by virtue of being a physically destructible copy (though I do consider physical a relevant form of preservation for all the patchless console gens). Everything less than DRM-free (or DRM-stripped) digital is ephemeral. PC is the only platform that's DRM-free by default, and fully abandoning physical copies a decade ago didn't change a thing for preservation.
Consoles will never give us DRM-free digital, because the only reason consoles exist now is to be DRM. So the only relevant preservation of console games is dumping and cracking and emulating, because that makes them DRM-free digital, even though they're not legally such.