I have seen your Asus BIOS info (I own another Asus Mobo too) and latest version clearly supports 14th Gen CPUs. Support is there since 1402, so BIOS is fine.
I still think you may be facing a system stability issue here, as reducing CPU clocks clearly mitigates the problem. You may want to try XMP II instead of XMP I. I have also a 6400 MHz Corsair RAM with an i9-12900ks and XMP I is not stable at all and has never been stable in any of my setups during the past years, resulting even in BSODs. If XMP II is not available you may have Asus OptiMem II available instead and you can also use it.
Make a copy of your current settings just in case, then load BIOS default settings (pressing F5), change to XMP II and select the correct RAM profile. Asus settings are always well optimized and most settings can be left on Auto or to the values proposed by Asus defaults (which is most cases will be also “Auto”). I never had to manually tune my BIOS in years by using this method and I always had stable systems.
About current market practices and known technical issues, well… There´s still a chance of that, sure. Windows itself is not handling P and E cores properly and HAGS is not yet stable at all, resulting in many problems when running DX12 or games that use frame generation like MSFS. The arrival of 14th Gen just put more stress on systems on top of that. Problem may not be the CPU itself but the whole current ecosystem. HW seems to evolve faster than the rest, while it still needs the rest to perform optimally.
Cheers