[Persistence] Query does not report failure correctly

[Arkatufus]

Related to #5824

Failure in AllEvents query is reported on debug level, which is incorrect. It seems like error and failure handling in Akka.Persistence.Query is not standardized. We need to standardize error and failure reporting in Akka.Persistence.Query.

[Arkatufus]

This is actually not a bug, the original issue stemmed from the fact that the Task was not await-ed, making it a detached Task. The exception thrown by the stream supervisor was not caught.