Do not want mail program talking to some third party cloud service.
Anyway, assuming you're talking about Sync, I find it quite helpful for the browser so have no issues with it being extended to Thunderbird. It is, as I understand it, always optional, and I even believe it's possible to self-host it, though I haven't tried.
off my head, first you have to get the account service up and running then you can get the sync service going then you have to trick your firefox installation to use your services.
That said it would be even better if I could sync through my own Nextcloud instance instead of through Mozilla Sync.