Add pipeline validation failure description

What does this MR do?

Closes #55695 (closed)

Screenshots

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• N/A Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• N/A Database guides
• N/A Separation of EE specific content