Files that are stored in iCloud Documents will also not be backed up by Time Machine. Huge mess if you ask me. I therefore don't use iCloud Cloud storage anymore. It's just too complicated to reason about.

Source: https://eclecticlight.co/2022/02/21/can-you-back-up-icloud-d...