Oh yeah, I have the same thing with a 7900X3D on an Asus ROG Strix E-F with AGESA labelled 1005c_RC3 in the BIOS - probably very similar.
It was playing nice when I first installed it, but switched on boost override a couple of weeks back and now I look at it, cinebench r23 single core wants to spread threads over CCD0. When I put override back to auto it behaves as it should and starts using a smaller number of frequency cores.
I had also failed to get CPPC dynamic preferred cores to do anything in the BIOS, but when I roll back the override, this does appear now to result in the frequency cores being favoured.
Good catch!!
Asus looks to have a new BIOS based on 1.0.06 published today but no explanation of what it does and I won't rush to install it