A console is possibly the worst DRM you can have.
Depends on the console. If you do t have huge online/patch reqs, then you can play for a very long time. I have had a few diff Dreamcast, SuperNintendo, Genesis, PSX, PS2, etc consoles, replacing/repairing as they broke. I sure as hell didn't have to worry that since Sega is out of business, I can't play my games.
For more recent consoles, DS, PSP, Vita, WiiU, 3DS and PS3 are also mostly ok with PS4 being more questionable due to patches but even though cruel be backed up through HD backup. Not sure about 360/Xbone.
However, this sort of a trend breaks with PC games with Denovo or online reqs with console games. Denuvo in particular may cause some games to never being broken due to the way their algorithm works since pirates will move on a lot of times before games could be cracked.
The 30 year examples here are nuts. No guarantee of even 10 years here which could be unfortunate (see iOS gaming situation for how badly preservation can be screwed up). I still play games from 90s, so over 20 year old, not to mention 10.
So yeah, on one hand it's understandable that pubs/debts want Denuvo. On the other hand it blows chunks for customers to potentially lose capability to play the game down the road, to be able to mod, heck, to be able to cheat in SP game with CheatEngine.
And the funny part is for all the arguments in the thread nobody can show actual positive trends with utilizing Denuvo. Doom was one example given as potentially positive. This is one of the best FPS of its kind ever released and still under million sales on Steam. I would venture to guess that it's hard to see how antiPiracy prevented jack here. Would Doom be only 500K without Denuvo or would it be maybe only 50 K less sales which would maybe correspond with the cost of Denuvo implementation. Who knows, but the effort of finding g evidence shouldn't be o. Th shoulders of only anti-Hard DRM team.
Hell, look at Witcher 3. It sold very, very well. Could we postulate that presence of Denuvo would have significantly improve sales? Somehow I doubt it.
So on one hand we do have evidence of games not working due to DRM, GFWL/SecureROM and probably more. On the other hand we don't have evidence one way or the other about improving sales.
Personally, again, I would be a lot more comfortable with the software DRM in question if pubs/devs committed to take Denuvo out in a year or two, but I don't see that happening.