Fix opentelemetry test

[sfc-gh-yuwang]

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

   snowpark daily precommit pipeline was broken because of opentelemetry test.
   There is no recent change of opentelemetry and the precommit test started to fail since SNOW-1557229: Add method to replace child for LogicalPlan and derivatives #1987, the root cause is still mysterious to me, but I don't think we should spend a lot of time on digging it, so I moved them to integ test and removed redundant tests. I have confirmed that our code coverage is not affected.

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.

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

   Please write a short description of how your code change solves the related issue.

[sfc-gh-yuwang]

After consideration, I decided to move tests to integ test and remove redundant tests

[sfc-gh-yzou]

I really doubt it is cause by the pr linked there, because that pr seems just adding a function that is not called by anyone. Also, the test actually seems flaky to me, I see sometimes it fails on windows, sometime on azure etc. if it is caused by that pr. If moving the test can make it stable, we can do that.

[sfc-gh-yuwang]

I really doubt it is cause by the pr linked there, because that pr seems just adding a function that is not called by anyone. Also, the test actually seems flaky to me, I see sometimes it fails on windows, sometime on azure etc. if it is caused by that pr. If moving the test can make it stable, we can do that.

I am also not sure what exactly caused it, the past daily precommit before that PR seems to be stable. I found it really hard to debug this flakiness because it only appears in daily precommit. So I just move all of them to integ test because that has always been stable, I also made sure that our code coverage does not drop