This is another shining example of Asus's crappy software.
The Alteration Mode Switch on the X670E Crosshair Hero only gives you an option between PCI-E Linkspeed and Fan Profile.
Only setting this setting to 'Fan Profile' allows the 7900 XTX to run ...