The problem is the local storage on the phone. The middle picture showing device backups isn't a problem - you have plenty of space in the cloud.
If you can't figure out how to prune what's app - you can try their support and/or deleting the app and letting the storage stabilize over a day.
Once you know how much free space of the 16 GB is available without over half being taken by WhatsApp - you can then document that and re-download that one app.
Things won't work well until you free up a GB of space and it looks like WhatsApp is the only possible solution to your current jam.
Can you still search the contents of those files in Spotlight?
Yes, for a while. Spotlight doesn't purge the files from the index (./Spotlight-V100), however it doesn't particularly ensure they remain.
Therefore, when macOS stores a file in iCloud and removes it from your home folder, the Spotlight index retains an index of the contents, but doesn't actively refresh the index. For example, resetting your Spotlight index will remove the file contents from the index. To add the files back, download them from iCloud, at which point Spotlight will index them once again.
What happens to those files in Time Machine backups?
Time Machine does not back up files in iCloud. They are ‘presumed safe’ in the cloud. They will remain on any older backups, but new incremental backups will observe the files as having been deleted.
If you restore a Time Machine backup on to a new Mac, you will log in to iCloud as part of the Setup Assistant, at which point the files will be accessible once again as normal.
Also, what happens if you edit those files on an iPad? Will the files be automatically downloaded again to the Mac?
Optimize Mac Storage attempts to keep your recent files available on your Mac. Therefore, when a file is edited by any device, your Mac will download the file locally, in case you want to continue editing there.
If not, can you search the new contents of those files in Spotlight?
Since the files are downloaded on editing, the new contents will be made available in the Spotlight index when the index is updated.
Will new Time Machine backups have a local copy with the new contents, the old contents or no local copy at all?
If a backup takes place whilst the file is downloaded, the new contents will be backed up. If the file is only in the cloud when Time Machine performs a backup, the file will not be backed up.
Best Answer
First and foremost: iCloud is not a backup service. In order to achieve what you want, you need backups!
You can use various forms of backups to realize your goal: For example you could use the built-in Time Machine software with external USB-drives in order to have a complete backup that you could store at a seperate location. You could also use a cloud service such as Backblaze, SpiderOak or similar.
That being said, you can avoid the Mac removing files from your local disk to free up space by opening up
System Preferences, clickApple IDand then remove the check mark fromOptimise Mac Storage.