TLDR: Terraform should use Vault for storing secrets in state, but does not support it yet.
(it is occasionally unavoidable storing secrets in state due to resources orchestrated)