Reveal in Finder on MacOS not working

I think you’re going to have to investigate what Sonoma has done to your iCloud Drive files.

Do you know if iCloud has finished downloading everything, per the above article?