FWIW I had similar concerns and here is my suggestion :
- no physical player or even DVDs... just get DRM-free files
- if you still do want to do the whole thing offline I bought a brand new 20€ DVD player with USB input to plug on my Linux computer
- I then installed
dvdbackup - use it to get VOD files
- read directly with e.g
vlc - compress with
ffmpeg
- I then installed
Might sound complicated and first time maybe it took me 1h to setup, now I put a DVD in, start my script and 15min later I have a video.mp4 with everything I need. I can play it locally, share on LAN with miniDLNA and let any other device (phones, video projector with VLC, etc) play the content.
I then frequently go to my public local media library, get the content I need legally and the right holders get their cut, no data going to BigTech platforms.