Considering both Xbox and PlayStation consoles support DVDs I think there will be quite a long tail for playing DVDs.

Disappointing, but that's the harsh reality of how the market works. Convenience wins. Which is why physical media sales first suffered (allegedly) from piracy; I don't think it was primarily to avoid paying for stuff, but because having years of music in a winamp playlist was much less hassle than managing a CD collection.

Piracy was ultimately defeated or at least greatly diminished thanks to streaming services. It's making a comeback now due to increased prices and fragmentation though (and to a degree, the politics of prominent figures at these streaming companies - artists pulled their music from Spotify out of protest).