New Aida64 v6323 is out, now i can confirm all the issues with the CPU temp lock on Asus Prime x670-P motherboard has been completely fixed.
All 3 sensor options work as expected: CPU, CPU Package and CPU Diode.
Remember to restart the computer after upgrading to the new beta version before the changes actually takes effect. (it might give false positive of not working if the computer is not restarted after the aida64 upgrade)
Thanks @Fiery and the Aida64 team for great effort!
Cheers!