status=draft returns published records in Strapi v5
### Node Version

20.10.0

### NPM/Yarn/PNPM Version

npm v10.2.3

### Strapi Version

5.7.0

### Operating System

MacOS

### Database

SQLite

### Javascript or Typescript

Typescript

### Reproduction URL

_No response_

### Bug Description

In Strapi v5, querying the REST API with status=draft returns all draft versions, including those that have already been published. This makes it impossible to query records that have never been published (i.e., true drafts).


### Steps to Reproduce

**To Reproduce**

1. Create a collection type with draft & publish enabled (e.g., species).
2. Create one record and publish it.
3. Create another and leave it unpublished (draft).
4.Query:

```
/api/species?status=draft
```

→ Returns both records, even the one that's already published.

5. Try to filter like:
```
/api/species?status=draft&filters[publishedAt][$null]=true
```

→ Still returns both records.

### Expected Behavior

```status=draft``` 

should return only records that are not published (or at least respect the publishedAt: null filter).

Or: ```publishedAt: null``` filter should work regardless of status.

### Logs

```shell

```

### Code Snippets

_No response_

### Media

_No response_

### Additional information

_No response_

### Confirmation Checklist

- [x] I have checked the existing [issues](https://github.com/strapi/strapi/issues) for duplicates.
- [x] I agree to follow this project's [Code of Conduct](https://github.com/strapi/strapi/blob/develop/CODE_OF_CONDUCT.md).