Long-term data storage is a complex and very interesting topic. Failing digital storage media are a big problem – especially when looking at the enormous amount of data they hold nowadays.
I'm skeptical when it comes to claims about longevity of media. "Our XYZ-super-mega-archive-thing survived in a chamber with 90°C, ultraviolet radiation and extreme humidity for the time amount of […]. This means it will last 200 years under normal conditions." This might be true or false. More important is that the console is able to read your CDs without any errors or crashes (compatibility). I've good experiences with Verbatim blanks – both with compatibility and durability (at least for about two decades, none of them got unreadable) – but they're pretty expensive. No experience with that special product you linked though.
For console games I would rather think about the durability of the lasers than the discs. PlayStation 1 consoles are mostly over twenty years old – depending on usage the lasers already failed or are about to do so.
Since the optical drives are often the first thing to give up in consoles it might be better to replace the discs with other loading methods (optical drive emulator, FMCB on PS2)
Good luck and have fun!