[Epic] Release Updates

[emmyoop]

Bugs + Features for the dbt-core + adapters release process

Bugs

Beta Give feedback

1. Fix latest tag in GitHub releases #73
   bug +1
2. [CT-2828] Fix pre-commit failures when cutting a new release branch actions#121
   tech_debt +1
   
3. [CT-2437] [Bug] Fix when the release test branch gets bumped actions#92
   bug tech_debt +2
   
4. [CT-2255] Add retry logic to nightly installation tests actions#85
   Team:Adapters tech_debt +2
5. Stop letting code cleanup steps fail #72
   tech_debt +1

Improvements

Beta Give feedback

1. Remove commit sha from release inputs #69
   +0
2. [CT-2398] Automate changelog consolidating when cutting the first rc #78
   tech_debt +1
3. [CT-2815] Deprecate version_to_bump_main in cut-release-branch.yml actions#115
   tech_debt +1
4. [CT-2433] Add latest Previous Release to Changelog List actions#91
   +0
5. Split up tests in release #88
   tech_debt +1
6. Add final release step to clean up branches and draft release #70
   tech_debt +1
7. [CT-2146] Reusable Workflow for Branch/Release Cleanup actions#78
   tech_debt +1
   
8. [CT-2032] Make fetch-repo-branches smart enough to only return what we support actions#74
   tech_debt +1
9. Convert PyPI Auth Method to Trusted Publishers #84
   enhancement +1