[TEST] StatementResourceSuite - query cancel *** FAILED ***

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

### Search before asking

- [X] I have searched in the [issues](https://github.com/apache/kyuubi/issues?q=is%3Aissue) and found no similar issues.

### What kind of test improve?

- [X] Fix flaky tests.
- [ ] Fix bug in tests.
- [ ] Increase test coverage.
- [ ] Other kinds of test improve.

### Describe the issues of the existing tests or improvements for new tests

```
- query cancel *** FAILED ***
ERROR did not equal CLOSED (StatementResourceSuite.scala:96)
```
https://github.com/apache/kyuubi/actions/runs/4444561075/jobs/7802871005

### Are you willing to submit PR?

- [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to improve.
- [X] No. I cannot submit a PR at this time.

Start with StatementResourceSuite.scala at line 96 and review the failed query-cancel run linked in the issue. Reproduce the failure and make the test reliably reach the expected CLOSED state, then rerun the relevant StatementResourceSuite tests.

Written by the indexing model from the issue text.