What does this PR do?

This PR fixes issues with ESS stack cleanup in CI by:

• Moving the ASDF_TERRAFORM_VERSION definition to the global pipeline environment so it is available to all steps, ensuring asdf provides the required terraform binary.
• Passing the ess_region variable explicitly to terraform destroy in both Bash and PowerShell scripts, since it is required to properly clean up FIPS ESS stacks that do not use the default region specified in Terraform files.
• Ensuring the correct set of Terraform environment variables is consistently provided during ESS stack cleanup.

Why is it important?

Without these changes, ESS stacks are not be cleaned up correctly after CI runs due to missing terraform binaries, unset environment variables, or incorrect region handling. This results in orphaned cloud resources, higher costs, and hitting stack quotas, which can block new CI runs from provisioning fresh environments.

Before this PR link. With this PR link.

Checklist

• I have read and understood the pull request guidelines of this project.
• My code follows the style guidelines of this project
• I have commented my code, particularly in hard-to-understand areas
• I have made corresponding changes to the documentation
• I have made corresponding change to the default configuration files
• I have added tests that prove my fix is effective or that my feature works
• I have added an entry in ./changelog/fragments using the changelog tool
• I have added an integration test or an E2E test

Disruptive User Impact

None expected. These changes affect only CI pipelines and cleanup scripts.

How to test this PR locally

Open a draft PR and see that ESS cleanup steps are actually cleaning up the stacks.

Related issues

N/A