Issue #3531646: Add `messenger:failed:show` command

https://www.drupal.org/project/sm/issues/3531646

Version built on the retry-failed MR !33 (merged) instead of the combined retry-failed-rate-limiter !30 (closed) branch.

Replaces !32 (closed)