Migrate tests in google/cloud/operators from unittest to pytest (#29775)

https://github.com/apache/airflow/commit/b8bd2abb3e871ccb038810f0ffc41ecd6f2af1fa