chore: improve error message when local replica not running

[sesi200]

Description

The current error message for a non-running local replica is not great:

Error: Failed while waiting for agent status.
Caused by: An error happened during communication with the replica: error sending request for url (http://127.0.0.1:4943/api/v2/status)
Caused by: error sending request for url (http://127.0.0.1:4943/api/v2/status)
Caused by: client error (Connect)
Caused by: tcp connect error: Connection refused (os error 61)
Caused by: Connection refused (os error 61)

This PR adds a nice message explaining in understandable words what the problem is and what to do.

How Has This Been Tested?

added e2e, some manual testing

Checklist:

• [x] The title of this PR complies with Conventional Commits.
• [x] I have edited the CHANGELOG accordingly.
• [ ] I have made corresponding changes to the documentation.