Hi Tom,
Thanks again, whoops on screenshots, attached are example library specific screenshots and "get info" is the same value as finder list view of libraries.
Having a 12TB hard drive with 11TB used (per earlier screenshot) and having it take up 21TB+ of data on a backup is pretty crazy! Plus it is unreasonable cost wise, especially as this is one source drive of a dozen I need to back up. Perhaps the answer is in your drive format question?
The source drive is APFS and the backup volume is Mac OS Extended (HFS+) so perhaps that's the issue? Maybe a disk image clone is the only way to backup FCPX overblown library estimates without issue? Disk images feel very difficult to deal with, especially when you just need to recover one file, slow access, many reasons to avoid disk image, but grasping at straws here.
Anyhow, appreciate all your time and energy, this is a tricky one that perhaps others can benefit from a solution.
Michael
PS I found this on Carbon Copy Cloner help page, just sent them a query, not sure if there is a solution there:
Disk usage math is not straightforward
Disk usage is not a simple matter of adding the size of every file on a volume. Special filesystem devices (e.g. hard links) have always complicated this math, but more recently Apple has introduced more special filesystem devices that complicate this even further. The cloning feature in Apple's new APFS filesystem can lead to a scenario where it appears that you have more data on the disk than it can possibly contain, and the filesystem snapshots feature can lead to scenarios where disk usage is higher than the total size of the files on that volume. APFS also supports "sparse" files, which consume less space on disk than their file size would suggest. CCC can preserve sparse files between APFS volumes, but HFS+ does not support sparse files, so these files consume more space on an HFS+ formatted backup disk

