TST: Allow tm.network to catch urllib.error.URLError
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).

Addresses these flaky network errors due to external servers: https://github.com/pandas-dev/pandas/runs/4992270675?check_suite_focus=true

```
    def http_error_default(self, req, fp, code, msg, hdrs):
>       raise HTTPError(req.full_url, code, msg, hdrs, fp)
E       urllib.error.HTTPError: HTTP Error 500: Internal Server Error
```

Also modifies a condition that just because the test can connect to a "check url" (google) doesn't necessarily mean the test can connect to the target server.

@meeseeksdev backport 1.4.x Something went wrong ... Please have a look at my logs.