Show pinned notes by default on user profiles

What does this PR do?

Default to the "Pinned" tab on user profiles. This has been overwhelmingly requested by users since we created the tab.

Contribution Guidelines By submitting this merge request, you agree to follow our Contribution Guidelines

• I agree to follow this project's Contribution Guidelines
• I have made sure to test this pull request

added enhancement label

approved this merge request

requested review from @julia, @Leah, @Marie, and @dakkar

enabled an automatic merge when all merge checks for b477de1d pass

approved this merge request

mentioned in commit b7e6e13b

merged

mentioned in merge request !808 (merged)