Folders disappeared from iCloud Drive following path name change
Depending on the number of files you have, iCloud Drive can take a while to get itself situated.

I would move the files somewhere safe that is not part of iCloud and is easy to get to. Leaving them where they are should also work. Then, turn off iCloud Drive and follow all the prompts. It’ll want to “finish updating,” which you can skip. It’ll leave a folder in your home folder that’s an archive of some files it thought may not be uploaded yet.

Once everything is off, re-enable it. Wait until everything comes back. This can take a long time (hours) and it may look like nothing is happening. It will finish.

Once everything is back, make sure your data is all there and delete the old stuff.