What does an Application Credential provide?
An Application Credential is a separate credential that allows automation tools to access resources without sharing your user password. Keep access limited to the required scope and revoke credentials that are no longer used.
The product announcement on Discuss describes Application Credential management. The Terraform guide covers implementation details for that automation scenario.