Jonathan Mack

Not possible. Redshift is only a renderer and doesn't interface with Houdini's editing tools in any way. Maxon/Redshift would need to deliver these nodes as vex compatible ones to be used in SOPs. If they did they would also be available to Mantra. It seems unlikely that they would do so.

Edit:
As a possible work around, the specific pattern could be rendered on a card and used as a texture map with a texture read node in sops.

Revering the normals doesn't reverse the geometry. Use a reverse node to make the geometry right side out.

Why is it a strange result? The noise has values between 1 and -1, centered at 0. The 'black' pixels are actually negative. Alpha compositing isn't really meant to be used with negative alpha, so I'm not sure what you expect to see.