I have the same rig with brand new 6x ASUS DUAL 6600XT OC / MSI Z390 A-PRO mobo and 1x Corsair RM850x
I was having the same issue with TRM and got same error GPU 2: dectected DEAD. Got same message in every 15min until 2 hours constantly - tried many different OC settings.
Yesterday I put same OC settings as you had 965 core / 1100 memory and rig was running fine for 15 hours until today, when the same error appeared. I turned off my rig and changed risers between GPU 0 and GPU 2 to understand maybe it was a riser fault. Now my rig is up and TMR running again for 1 hour with 965/1100 OC settings at the moment for all 6 cards, waiting to see if that error would re-appear.
In the end what OC settings did you put to your ASUS DUAL 6600XT OC cards? How is it running so far? Are you using 900/1100 only for GPU 2 and GPU 5 and the rest are 965/1100?