It’s probably been about a decade since I bought a game on physical media, and that would have been a Nintendo product. I don’t think I’ve purchased a PC game on physical media for a couple decades, and yet I keep hearing about pirated copies of them. I don’t think physical copies disappearing will have a significant impact on the level of piracy in either direction.