Update automated workflows based on new ADRs

[RothAndrew]

Some of the stuff here won't take effect until it is in main. I did my testing over in this repo: https://github.com/RothAndrew/tmp-renovate-test

Breakdown of changes:

• Refactor the update-command workflow so that the bulk of the logic is in a reusable action, since it will now be used in 2 different places
• Simplify the if statements now that we aren't trying to run tests on push to main anymore
• Refactor parse logic to make it a bit simpler
• Delete auto labeling stuff
• Delete the pre-commit-trunk workflow now that we aren't trying to run it on commits to main.
• Simplify the github context name that the E2E tests use so that we can require them regardless of how they were triggered
• Update the auto-test workflow to:
  1. Only trigger if renovate is the author and the pull_request event is opened
  2. Checkout the branch
  3. Autoformat and push new commit if necessary
  4. Automatically add the /test all comment so that the tests are triggered.

BEGIN_COMMIT_OVERRIDE refactor(automation): refactor the update-command workflow so that the bulk of the logic is in a reusable action, since it will now be used in 2 different places (#323)

refactor(automation): simplify the if statements now that we aren't trying to run tests on push to main anymore (#323)

refactor(automation): refactor parse logic to make it a bit simpler (#323)

ci(pr-automation): delete the auto-labeling workflow (#323)

ci(main): delete the pre-commit-trunk workflow now that we aren't trying to run it on commits to main (#323)

refactor(pr-automation): simplify the GitHub context name that the E2E tests use so that we can require them regardless of how they were triggered (#323)

ci(test): update the auto-test workflow to reflect the decisions documented in ADR 8 (#323)

END_COMMIT_OVERRIDE

[zack-is-cool]

can you give a super high level overview on what changes are happening in this pr?

[RothAndrew]

Lol it's like I was reading your mind or something, I just finished writing it. See the PR description 😄