Did not know that. That sounds extraordinary wasteful, there must be a file hash based method that would allow sharing such files between domains.
it's a security feature. otherwise my malicious site could check for cdn.sensitivephotoswebsite.com and blackmail you if it was cached already
It offers security.
Just like you wouldn't use same table in your system for all users in a multi tenant application.