Had the same issue. Got ROG Strix X570-F Gaming, was doing a clean reinstall with CPU upgrade from 3800 to 5800. Updated bios to 4002 and installed this little bugger asus tpm-spi for a future win11 upgrade. So, it was not detecting at all after multiple bios reflash, CMOS clearing and battery swapping. But I got it detected by the following way, which is not safe, so you should not do it. This is clearly a bug that bios does not detect the module after cold plug-in.
So, what I did. With BIOS running, unplug tpm-spi module, then plug it back. All this with PC running with BIOS on the screen. Then click reset in the bios menu. After that it reset not once but two times, there were two sounds of successful POST within 20 seconds. After that I got a new option in the advanced section - trusted computing. After that PC boots always normally with module being always detected. But I did not try to clear CMOS, may be CMOS clearing will make the module undetectable again.
I read your thread here:
https://forums.tomshardware.com/threads/asus-x570-e-tpm-module-not-working.3712189/For me win10 saw the TPM 2.0 module right away after it was detected in bios. But I also have two secure devices in the device manager:
-AMD PSP 11.0 Device
-Trusted Platform Module 2.0.
But the first one does not cause any problems. As I understood from your thread at toms you had to disable the first one.
I think that due to this bug any CMOS clearing or bios reflash may remove the tpm module from the bios and cause win11 not to load... so you need to hot-unplug-then-plug it every time.
I'd appreciate if somebody would give me a link where I can make a ticket for asus support, may be they will fix it by the time win11 upgrade arrives to win10.