Improve `GroupDestroyWorker` failure logging related to snippets

Summary

Related to &7171

On Gitlab.com, GroupDestroyWorker sometimes fails due to a non-deleteable project. The failures are tracked in this Kibana dashboard.

We have narrowed down the failures to ten distinct Project#delete_error values. This issue deals with project deletion errors due to

Failed to remove project snippets. Please try again or contact administrator.

The full list of delete_errors can be found here: https://gitlab.com/gitlab-org/gitlab/-/issues/342692#note_737332055

Impact

In the past week, GroupDestroyWorker has failed ~1500 times due to 138 projects attempting to be deleted over and over again.

Recommendation

Verification