I really wanted to fix the color discrepancies between my render view and my actual render from the farm before I moved any further with look development. I knew the issue was somewhere in the ACES to sRGB pipeline conversion, so I started working from there. After reading the documentation for it and testing out several different things in my Redshift ROP, I still was getting a washed out render, so I took my files into Nuke to see if I could have more control over the color space.
Once in Nuke, it was pretty simple to set my project settings to ACEScg, which is what Redshift in Houdini uses by default. Then, using an OCIO node, I transformed the color space to sRGB and wrote out an image sequence from Nuke as a .png sequence rather than .exr files. With this, I was able to match my render view to my renders from the farm (big shoutout and thanks to T'Naige and Michael for helping me figure this one out).
I also did not know about using different color spaces for texture maps. There is an option to change this manually in each Redshift texture node, but there is also an option for using OCIO color rules in the Redshift render nodes, which automatically sets the correct color space for texture assets. So I turned this on as well.
I got a lot of great feedback from my peers for the current state of my project, so I'm glad the color management problem was a fairly simple resolve. For more information and my own future reference, the Redshift documentation for color management in Houdini was quite useful as well as this blog which breaks down some of the quirks of working in ACES.