For your 10 TB LaCie d2 Professional, I would use one GUID Partition Map, one APFS container, and four separate APFS volumes: one Time Machine volume and one CCC volume for each Mac.
APFS volumes within the same container share the container's available space, while optional quotas can limit how much space an individual volume may use. (Apple Support)
This arrangement is also consistent with CCC's current guidance. CCC recommends a dedicated volume for each Mac when backing up multiple Macs to the same APFS-formatted disk.
When Time Machine and CCC share the physical disk, CCC recommends giving Time Machine its own dedicated volume and applying a quota to it so that Time Machine cannot consume the space needed by the CCC volumes. (Bombich Support)
Your initial layout would therefore be:
LaCie d2 Professional 10 TB
└── GUID Partition Map
└── APFS Container
├── Mac 1 — Time Machine
├── Mac 1 — CCC
├── Mac 2 — Time Machine
└── Mac 2 — CCC
I would not create four separate physical partitions.
The APFS volumes provide the separation needed between the backups while allowing the 10 TB container's free space to be shared.
The two Time Machine volumes should have quotas appropriate to the amount of data on each Mac and the amount of Time Machine history you want to retain.
Apple confirms that Time Machine can use an APFS volume and that APFS volumes in a container share available space. (Apple Support)
One further consideration is that this 10 TB disk is a single physical device.
Separate volumes protect against accidental mixing of backup data, but they do not protect against failure of the LaCie drive itself.
A second backup device would therefore provide substantially better protection against physical-disk failure.
Apple's relevant documentation is here: Add, delete, or erase APFS volumes in Disk Utility and Back up your Mac with Time Machine.
To truly protect your non replaceable Data
Have a 3-2-1 Rescue Plan in place and always current
3 Backups using 2 methods and 1 off site incase of natural disaster or un-natural disaster.
Each of the above should be done to a Dedicated Single Purposed External Drive
Below link is intended to augment what TM Backup does
https://bombich.com
How to schedule a backup