[3.13] gh-128770: raise warnings as errors in test suite - except for test_socket which still logs warnings (GH-128726)

[3.13] gh-128770: raise warnings as errors in test suite - except for test_socket which still logs warnings (GH-128726) #62403