Pending Staff Review NRs showing when the search parameter is set to Draft.

**Describe the bug in the current situation**
In the Affiliations call, when the search parameter is set to Draft, the NRs with pending staff review show up, which are not actually drafts but their "StateCd: draft" object is Draft.

Steps to reproduce the behavior:
1. Go to 'https://auth-api-test-129641755850.northamerica-northeast1.run.app/api/v1/orgs/596/affiliations/search?status=DRAFT'
2. Execute the request
3. In the JSON Response, observe that all the NRs with "Pending Staff Reviews" show up

**Screenshots/ Visual Reference/ Source**

**Questions**
Which states should we allow the users to look at?

Start at the Affiliations search endpoint shown in the reproduction URL and trace how the status=DRAFT filter maps returned NRs to their states. Resolve which states should be visible with the maintainers, then reproduce the response and add or adjust coverage so pending staff reviews are excluded from Draft results while genuine drafts remain.

Written by the indexing model from the issue text.