Revert "gh-128770: raise warnings as errors in test suite - except for test_socket which still logs warnings (#128726)"#128936