Fix flaky tests

Several integration tests have been marked as flaky and are currently being skipped. With the recent introdaction of testcontainers-go for managing Cassandra clusters in test suite ([PR](https://github.com/apache/cassandra-gocql-driver/pull/1780)), we now have a more robust and flexible environment. I propose revisiting these flaky tests to address the underlying issues and stabilize them using the new testcontainers-go approach.

Start by reviewing PR 1780 and its testcontainers-go setup for Cassandra clusters, then identify the integration tests currently marked flaky and skipped. Investigate why those tests remain unstable and use the new environment to stabilize them; done means the affected tests run reliably instead of being skipped.

Written by the indexing model from the issue text.