the author can still sell the work, the NC prevents other people from profiting off of it without explicit permission (this does not prevent exemptions, work can still be sold under cc-by-sa as an exemption)
ukrainian cat ~
the author can still sell the work, the NC prevents other people from profiting off of it without explicit permission (this does not prevent exemptions, work can still be sold under cc-by-sa as an exemption)
or CC BY-NC-SA (the non-commercial-use-only one)
copyright will eventually expire after your death
and cc nc does not prevent derivatives, just profiting off of them without explicit permission, which is not that big of a deal