Physical media already somewhat obsolete in that vast majority of available media is used. Fewer and fewer new releases on vinyl or cd, especially true for cd. I continue to keep in touch with vinyl availability since I still run a pretty nice vinyl setup and titles available just simply pales in comparison to what is available on streams.
There have been some recent threads here which have spoken to the superiority of listening to the music vs the sound. If this is true than streaming wins hands down, so much music available and so easily accessed. And if sound quality is important, as I fully agree with, a properly optimized streaming setup can be a winner here as well.
My take is vinyl will never become totally obsolete due to unique sound qualities that are timeless. CD will die, it has no unique sound qualities vs streams, also more costly and more hassle.