Isn't it better and more accessible to mod existing roms to work with software emulators instead of doing the FPGA thing? It'll help you preserve the game just the same way and won't be as difficult as learning FPGA shit.
The route most normal people think when some code is buggy is to modify the code instead of making a whole new CPU. The ROMs aren't going to vanish just because there are no more CPUs which can run the same ROM.
I think what the society would benefit from is a centralized ROM Marketplace (Donation based) where you upload modded ROMs for obsolete consoles but of course because of how intellectual property works under capitalism this isn't possible.
As mentioned, FPGAs are super expensive, not very efficient and require a lot of knowledge of the underlying ICs.
Also there are no FPGAs for PS2 and other modern consoles