Include history for all client errors raised when fetching a URL

### Is your feature request related to a problem?

Currently, if we attempt to fetch a URL with a bad redirect that raises a DNS resolution error for which the root cause lies with a redirect, we cannot figure out the full redirect chain. Practically, imagine the following redirect chain, where the end does not resolve:

http://foo.com -> http://www.foo.com -> https://www.www.foo.com/test

A `get()` call will raise a `ClientConnectorDNSError`, and if we dig into it we can indeed find out the DNS resolution failed for www.www.foo.com, hinting at the fact we were redirected. This information is however incomplete:

* We don't know we went through http://www.foo.com in the process
* We don't know the path was `/test`
* We don't know the precise status codes of the redirects (301, 302, etc.)

### Describe the solution you'd like

I would like to have history available for all errors where history has been generated before raising the error.

### Describe alternatives you've considered

None are available, as far as I know.

### Related component

Client

### Additional context

_No response_

### Code of Conduct

- [X] I agree to follow the aio-libs Code of Conduct