SNOW-968914 Break waiting on pool destroy

[sfc-gh-knozderko]

Description

SNOW-968914 Break waiting on pool destroy

Checklist

• [x] Code compiles correctly
• [x] Code is formatted according to Coding Conventions
• [x] Created tests which fail without the change (if possible)
• [x] All tests passing (dotnet test)
• [x] Extended the README / documentation, if necessary
• [x] Provide JIRA issue id (if possible) or GitHub issue id in PR name

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 95.23810% with 4 lines in your changes are missing coverage. Please review.

Project coverage is 85.43%. Comparing base (45b428f) to head (6d04f60).

Files	Patch %	Lines
Snowflake.Data/Core/Session/SessionPool.cs	90.62%	1 Missing and 2 partials :warning:
Snowflake.Data/Core/Session/WaitingQueue.cs	97.14%	0 Missing and 1 partial :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## pool/SNOW-860872-connection-pool #953 +/- ## ==================================================================== + Coverage 85.30% 85.43% +0.12% ==================================================================== Files 106 106 Lines 10671 10742 +71 Branches 1026 1027 +1 ==================================================================== + Hits 9103 9177 +74 + Misses 1319 1317 -2 + Partials 249 248 -1 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.