I am not syncing my Desktop & Documents Folders on iCloud, nevertheless Apple thinks the Documents folder should live forever on my iCloud Drive. I could not rename it, I could not delete it.
Until some clever user pointed out the solution on Apple forum: If you are not able to delete the Documents folder on iCloud, try to drag it first to the desktop, and then delete it from there.
It works! Thank you!