Clarify pipeline documentation

What does this MR do?

Closes https://gitlab.com/gitlab-org/quality/team-tasks/-/issues/301

Screenshots

Does this MR meet the acceptance criteria?

Conformity

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