I still buy physical media for the things I really care about but have otherwise thrown in the towel for any hope that its demise isn't far off. I'm guessing within ten years or so. I want to be wrong about this though.
About the only thing I could see that might change this is if the powers that be find a different medium that's cost-effective enough, and as universally supported as the optical media has been, with the storage capacity that's needed. Flash, NAND, etc., something. We seem to have no problem with file formats but a low-cost storage solution is an issue. I know some experiments have been tried but it's never really been pushed and it doesn't appear that it will be any time soon.