tests(bigquery): implement robust wait loop for socket leak tests

tests(bigquery): implement robust wait loop for socket leak tests #5236