[CI][Dev] Remove pull_request_target for workflow labels "awaiting xxx" #55411

Describe the enhancement requested

The "awaiting review"/"awaiting committer review"/"awaiting changes" labels on PRs were added trying to help with a workflow that has never worked.
As we have to remove the pull_request_target event from our workflows I'd recommend removing the whole workflow and revisiting in the future how to improve our workflows.

Component(s)

Continuous Integration, Developer Tools