Physical media is dead.
I only use my disk drive to burn CDs for my car since its stereo is from 2001 when people still used those archaic disks.
I'm really hoping that comment was dripping with sarcasm and that you're not just a Jobs drone...
Physical media will never be "dead" due to the simple fact that it's far easier and cheaper to manufacture/press discs than it is to load data on a SD card.
I mean, for a company that's pressing Blu-ray discs, let's assume that the cost per disc is $2 (which seems to be about the consumer cost for a 25 GB disc, presumably such a company would get a large discount for bulk orders... so it's possible they could get double-layer discs for this price)
Meanwhile a 32GB SD card seems to cost around $70 for consumers.
Clearly SD cards aren't a very good alternative for distributing media (and probably won't be for a long time).
You may also claim that your precious iTunes can download all this content, but I will state that iTunes' version of Planet Earth (I downloaded the free episode) is just awful when compared to the Blu-ray version. There's plenty of visible artifacts from the compression.
And if iTunes was to offer Blu-ray quality content (which would have to be just as high of a bitrate as the Blu-ray movie, since Blu-ray uses h.264 compression as well) then your harddrive would fill up extremely fast. I mean, a 500GB drive could only hold 10 full double-layer Blu-ray discs. That's also not a very cost effective method of storage.
And with the move to more-expensive solid state drives... storage space will be even more valuable. Especially with Macs, since most of them can only have ONE disk drive. (two would be possible in most if you removed your SuperDrive... but then you lose the useful capability of reading/writing DVDs)
In any case, getting back on topic: I'd say a SuperDrive would be worth it... I mean, remote install of software sounds like a drag, unless you readily have another computer available at any time you would ever want to install software. Also, what do you do if someone gives you a DVD/CD while you're on a trip with files on it? Wait until you get home?
If I'm giving multiple people files to keep, I may just burn some DVDs, since it's a whole lot easier than passing around a USB drive or SD card (which some people might not have built-in slots for).