[CT-1505] [Feature] Freshness checks should repeat errored tests at the end

[FridayPush]

Is this your first time submitting a feature request?

• [X] I have read the expectations for open source contributors
• [X] I have searched the existing issues, and I could not find an existing issue for this feature
• [X] I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

DBT's command dbt source freshness performs a test against all sources in a project. However if there are a long list of sources, say 70+, one error or warning gets lost in the results printed at the end. Additionally there is no text printed that lets a user know any test failed.

There were 2 failures and 2 warns on that run. I would like to propose a final paragraph similar to dbt test that lists all failed source checks, and lists warnings.

Describe alternatives you've considered

No response

Who will this benefit?

CI and Manual runs of source freshness checks will be easier to mentally parse with a summary block at the end of a run. Additionally printed text of the result, rather than only relying on exit codes, would be appreciated.

Are you interested in contributing this feature?

No response

Anything else?

No response