In a 100 (or a few hundred) years none of the games from that physical archive will be playable, as both the physical media and the physical consoles needed to play those games will become unusable. Physical archives work only as long as the physical medium itself lasts.

The only way to actually preserve games is to digitize them. Period. Collecting physical media and consoles is a fun hobby, but in the long term it's completely useless if the goal is preservation. If you want to preserve games you should be dumping whatever undumped games still exist, contribute to databases like no-intro.org, and download and seed/share what has already been dumped. This is what will help preserve those games, not a physical collection that will turn into an unusable paperweight sooner or later.