Before you go nuclear in trying to figure out why some of your application folders in iCloud Drive went missing… a simple thing that worked for me, restart your computer.
More complex solutions in case a restart didn’t work which may help are suggested at https://apple.stackexchange.com/questions/316554/why-some-icloud-folders-do-not-show-up-in-finder.