Still got some but I only have a couple dozen.
I quit buying physical media many years ago.
Just not any point, It's never more convenient to carry around a physical book to read when I already have a tablet that has hundreds.
I'm never going to want to have to physically find and insert a dvd or bluray just to sit through previews and warnings that I'm only subject to because I dared pay $20 for a physical disc.
Plus they're impractical for the same reasons as physical books.
I can watch pretty much any movie on my phone now from practically anywhere.
The only thing I think you might regret and realistically this is only a concern for older releases as this is pretty much completely not a thing anymore is the disc bonus features. Most modern stuff just flat doesn't have anything extra but used to you could get director's commentary and deleted scenes and stuff on the disc, things that online releases don't often include.
I mean if you're running it in a dashcam yeah, absolutely have to spend the extra few bucks for an endurance rated one.
Nah not anywhere in my list of reasons this would be a bad idea.
I highly recommend against using them on two points
They are more fragile and easy to break than they look, especially with age they get so brittle that they will physically break apart even without being mistreated.
Their most common way of failing aside from physically breaking apart is silently corrupting data. What you put there won't match what you get back immediately after being written.
So if you still want to use it for backup I highly recommend ensuring whatever your using for backup can both verify the written data matches the original and alert you the card has failed if it doesn't and have some way of verifying that the files haven't been corrupted since then.
That way you can tell which if any of your two copies are good.
Also get it to handle minor corruption if you can like with par files or something so even if both partially fail your still have some ability to recover.
These are good recommendations for any storage media but sd cards and flash drives are just particularly bad at this IME.