Clarify that Password authentication must be enabled for OAuth flow

What does this MR do and why?

Contributes to #454286

Problem

Resource owner password credentials flow doesn't work when Password authentication option is disabled for the GitLab instance.

See thread: #454286 (comment 1867091118)

Solution

Add a note to the documentation that explains that.