You could try exporting the video from FPCX with Animation compression and see how it comes into AE. And I wonder if this will help at all. I had the problem in AE 2022 where videos would be solid green, which is different than the problem you're having, but maybe this solution will help, which I found in this thread
YOU MUST DO STEPS BELOW IN THIS EXACT ORDER....
Disable hardware acceleration in Preferences/Import
Clear BOTH disk caches in this order Preferences/Media Cashe, and then Preferences/ Disk Cache
Check the footage interpretation and the color profile. The rest we can't realyl know without any proper info about the footage, CM settings, your system etc..
Well the clip is ProRes 4444 that was exported out of FCPX through Compressor. I know there is nothing wrong with the clip because it is fine when imported back into FCPX, Motion and even Premiere Pro. The problem only exsists after I import into After effects. There will be a couple of frames out of the 2 second clip that have a green tint. Very noticable when plating back.