Enable goreleaser debug logging for all non-nightly releases

[timflannagan]

This is useful during release time to better debug issues when the goreleaser step fails in the release workflow.

[NishantSinghhhhh]

@timflannagan, @lgadban can I work on this issue, I will be easily able to add goreleaser in the codebase

[github-actions]

This issue has been marked as stale because of no activity in the last 180 days. It will be closed in the next 180 days unless it is tagged "no stalebot" or other activity occurs.