ci: Add attempt number to the workflow run name, and URL in the slack message

[NickLarsenNZ]

Update the slack notification to link to the exact workflow run.

[!NOTE] Changelog not updated as the changes seems too minor

Slack conversation