Change the slack notification comment link.

## What does this MR do?

Changes the link in Slack notifications for comments.

## What are the relevant issue numbers?

Closes #24107

See merge request !7498