Improve UX of pipeline failure notification emails

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

Description

Today when a pipeline fails, a notification email is being sent. When a pipeline fails because of a build being retried by someone who is not the original author of a pipeline this is confusing, because the information about the person who triggered the build is not visible in the email:

failed_pipeline_2024-04-18_15-44

If it would be another team member who retried a build, I would get this notification again, and this can be surprising by people who receive such an email.

/cc @sunjungp

Edited by 🤖 GitLab Bot 🤖