According to DoesItPlay.org, only 13% of PS4 games required a download to play. When you look at PS5, it's only 17% requiring download.
Microsoft actually implemented the opposite of your described sharing method recently. When you first put in physical media, you are allowed a digital download of that until that disc is put into another Xbox, where the license is immediately transferred.