I used to use it, I now use Cookie AutoDelete [1]. It's especially a nice on-boarding experience: at first the cookie Auto-clean deletion is disabled so you have time to whitelist the sites you want, and then you turn it on.
It also support Multi-Account containers[2], so you can whitelist a particular site only in a particular container. This is obviously a new feature compared to Self-Destructing Cookies since Mutli-Account containers didn't exist back in the time.
[1] https://addons.mozilla.org/en-US/firefox/addon/cookie-autode...
[2] https://blog.mozilla.org/firefox/introducing-firefox-multi-a...