With a lot of companies no longer doing physical games, then would that give rise to more Piracy?

Probably about the same. People always find a way.

How will video game preservation work then?

Games are just data, whether physical or digital. What gets lost is the servers for online functionality an such.