Update 'Visibility of pipelines'

What does this MR do?

Improve documentation for Public pipelines option

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• Conform by the style guides
• Squashed related commits together

What are the relevant issue numbers?

Closes #34360 (closed).