Avoid listing snippets in GraphQL when user profile is private

What does this MR do?

Refs #300732 (closed)

In this MR we, try to align better the behavior of GraphQL and the user profile status. If the user profile is private and the user cannot see the profile, then we don't list any of the user's snippets.

Does this MR meet the acceptance criteria?

Conformity

• 📋 Does this MR need a changelog?
  • I have included a changelog entry.
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Separation of EE specific content