Mention limitation of requirements.txt in Dependency scanning docs

What does this MR do?

Mention limitation of requirements.txt in Dependency scanning docs

Related issues

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/52824.

Author's checklist

• Apply the correct labels and milestone
• Port the MR to EE (or backport from CE): always recommended, required when the ee-compat-check job fails

Review checklist

• Your team's review (required)
• PM's review (recommended, but not a blocker)
• Technical writer's review (required)
• Merge the EE-MR first, CE-MR afterwards