tests: avoid requests exception tracebacks

In case session.head() raises an exception (typically for connection failures), then log it as string, rather than letting it bubble up to pytest, which will then print the whole traceback from requests itself.

This also reverts the changes from !659 (merged), which resulted in worse behaviour changes (see my explanations there, and in the revertion commits).

Closes #141 (closed)