Nope it won't. Nearly all RRoD's are from the BGA socket for the CPU failing, where it no longer makes sufficient contact with the interconnects.
Well, it's basically caused by overheating right? Where the solder points are melted. Going from an active cooling system to a passive one will most likely increase the temperatures in order to dissipate the same energy, I'd think?