SNOW-1709861: table clean up uses its own cursor

[sfc-gh-aling]

1. Which Jira issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes SNOW-NNNNNNN

2. Fill out the following pre-review checklist:

   • I am adding a new automated test(s) to verify correctness of my new code
     • If this test skips Local Testing mode, I'm requesting review from @snowflakedb/local-testing
   • I am adding new logging messages
   • I am adding a new telemetry message
   • I am adding new credentials
   • I am adding a new dependency
   • If this is a new feature/behavior, I'm adding the Local Testing parity changes.
   • I acknowledge that I have ensured my changes to be thread-safe

3. Please describe how your code solves the related issue.

auto table clean up could be kicked off by python gc at random timing, this caused flakiness in our async query execution as the random execution of async table clean up might overwrite the status of the shared session object leading to incorrect async query id being stored.

to improve, here we create a low level new connector cursor to execute drop temp table each time to avoid side effect

[sfc-gh-aling]

successful daily precommit running without any flaky test: https://github.com/snowflakedb/snowpark-python/actions/runs/11372006647