Releases are not automatically deleted when deleting corresponding tag

What does this MR do?

Currently, Releases::DestroyService checkes if the Release entry has an existing tag. If not, it doesn't destroy the entry.

This is a wrong implementation that Release entries which don't have an existing tag is an orphaned entry which should have been removed (cleanup). Basically, all Release entries are tightly coupled with an existing tag from data integirity perspective.

What are the relevant issue numbers?

close https://gitlab.com/gitlab-org/gitlab-ce/issues/57380 https://gitlab.com/gitlab-org/gitlab-ce/issues/57980

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• [-] Documentation created/updated via this MR
• [-] Documentation reviewed by technical writer or follow-up review issue created
• Tests added for this feature/bug
• [-] Tested in all supported browsers
• Conforms to the code review guidelines
• Conforms to the merge request performance guidelines
• Conforms to the style guides
• Conforms to the database guides
• [-] Link to e2e tests MR added if this MR has Requires e2e tests label. See the Test Planning Process.
• Security reports checked/validated by reviewer