Good news and bad news, it's not Corsair's equipment making the noise. It's actually the useless mini fan most x570 mobo's have on the southbridge.
My mobo brand has a famously horrible noisy fan on it and I usually have it turned low but when I got my 3080 I turned it to 30% which is nearly inaudible, however, recently I've been hearing fluctuating frequencies and being pretty sure it's that fan I went into BIOS to lower it. Every time a change is made to that fan it revs up then lowers to whatever duty I set, and doing this is how I found out it's not the Corsair AIO pump as every time I made the change the grinding would kick in.