TLDR: It’s compatible with other copy-left licenses like GPLv3. However, it’s available in multiple languages, which technically makes it more applicable.
I started using it for my own project. If you want a practical example: https://github.com/TimoKats/emmer
That would be CC BY-NC-SA.
Creative Commons,
Attribution,
Non-Commercial,
Share Alike.
Meaning you need to attribute to the original author, can only use it for non-commercial purposes, and must share alike (i.e., your derivation must have the same attribution rules).
Imho there should be a “Commercial only for worker co-ops” option.
Maybe we also need to consider internet content and written books by default as something not allowed to be scraped by AI. Only that which is in public domain may be scraped.
Practically all the free software licenses require some form of attribution. CC licenses are not really suited for code. I would say the GPL is way more applicable here.