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).