Avoid returning deployment metrics url to MR widget when the deployment is not successful

Closes #53870

See merge request gitlab-org/gitlab-ce!23010

(cherry picked from commit 7674a8f4)

e270fcc8 Fix deployment metrics in MR widget
15431054 Add spec for deployment metrics
2d6570f0 Do not remove the existing permission check
09e693c6 Add changelog
d8c24ac1 Remove unrelated changes