Went from a launch Pro to the RDR2 bundle, and I can confirm it's basically night and day from a noise level perspective. It does spin up a bit still, but the pitch isn't anywhere as egregious as my launch, and a lot of times it will actually dial back the fan pretty quickly in scenes where it's not needed, where my launch would go to 100% within 2 minutes and never go back down until I went back to the XMB.
Also, my Pro sits on my desk, so it's more noticeable for me personally. If you have your Pro sitting in a living room environment several feet away from you, you may not even hear it over the ambient noise in the room.