Bug: handle and report `ErrorResponse` message type

### Bug description

Currently this message type is not properly unwrapped and reported, beyond this:

```
logical replication error: unexpected message type *pgproto3.ErrorResponse
```

### Steps to reproduce

Not sure

### Version

latest