There are still lots of games that run from the disc. I just got the BG3 collector's edition that came with two disc's for that reason, same thing with Final Fantasy VII Rebirth, and others. I've played my Dark Souls 3 disc copy when I was going a little crazy from an internet outage before. There's others. It's mostly single-player of course, and you'll miss day one or future patches, but they exist.

I mostly know this because I'm a console player and unless it's free to play or extremely cheap, I always buy disc's, and usually used.