[CT-2555] Release and tag latest container images

[dbeatty10]

Summary

Since 1.4.0, the lastest and 1.x.latest tags for ghcr Docker container image versions have not been applied:

### Release the latest container images
- [ ] https://github.com/dbt-labs/dbt-core/issues/7149
- [ ] https://github.com/dbt-labs/dbt-core/issues/9597
- [ ] https://github.com/dbt-labs/dbt-bigquery/issues/1113

### Tag latest container images
- [ ] https://github.com/dbt-labs/dbt-core/issues/7149
- [ ] https://github.com/dbt-labs/dbt-postgres/issues/9
- [ ] https://github.com/dbt-labs/dbt-snowflake/issues/597
- [ ] https://github.com/dbt-labs/dbt-bigquery/issues/941
- [ ] https://github.com/dbt-labs/dbt-redshift/issues/686
- [ ] https://github.com/dbt-labs/dbt-spark/issues/957

Here's a listing of the most recent tagged image of each:

• dbt-postgres
• dbt-bigquery
• dbt-redshift
• dbt-snowflake
• dbt-spark

[bdashrad]

It would also be nice to get semantic tagging, so you could pull a tag tag like 1.5 that would get the latest 1.5.x tag.

[raginjason]

Seems like this is at least related to or would be fixed by https://github.com/dbt-labs/dbt-core/issues/7149

[dbeatty10]

Re-opening until we decided how to handle each of the remaining items in the tasklist.

Resolved dbt-labs/dbt-core#7149 instead in the meantime.