Solution
Yes, the cRIO-PN-S module is compatible with the new cRIO-904x and cRIO-905x controllers. All you need to do is to make sure you downloaded the latest version of the cRIO PROFINET driver from the VI Package Manager. You can search for cRIO PN Device, it'll be the version 4.0.0.2, released by KUNBUS GmbH, as shown in the image below.
It is important to note that the cRIO-PN-S module won't be detected with an auto-detect procedure and must be manually added to the FPGA target and deployed.