zip: improve testing around redacted debug zip bundles

**Is your feature request related to a problem? Please describe.**
A few issues have come to my attention where incorrect queries used by the redacted debug zip were introduced.

**Describe the solution you'd like**
It should not be possible to introduce invalid queries to redacted debug zips.

This identifies a clear gap in testing that should be filled.

Update the debug zip testing to ensure that bad queries don't make it to the `master` branch.

Jira issue: CRDB-31635

Epic CRDB-39822

Search the repository for the redacted debug zip testing and the code that assembles its queries. First inspect the existing tests and query definitions to see how invalid queries are currently handled. Done means the tests prevent bad queries from reaching the master branch.

Written by the indexing model from the issue text.