fix: [CDS-100484]: Improve error handling and errors returned to user for gitops

[mteodor]

Describe your changes

Currently errors being returned when terraform fails are not very descriptive and make it hard to debug problem with terraform pipelines. This should wrap error returned from API and prepare it for Harness terraform provider to be able to include it in diagnostics.

Comment Triggers

PR Check triggers

- Build: `trigger build` - gitleaks: `trigger gitleaks`

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}