Remove override of vulnerability name specifically for Kics

What does this MR do?

Delete KICS specific name override in sarif.go

What are the relevant issue numbers?

Review rule name and description mappings in Kics (gitlab-org/gitlab#381652 - closed) • Joey Khabie • 17.2

Does this MR meet the acceptance criteria?

• Changelog entry added
• Documentation created/updated for GitLab EE, if necessary
• Documentation created/updated for this project, if necessary
• Documentation reviewed by technical writer or follow-up review issue created
• Tests added for this feature/bug
• Job definition updated, if necessary
  • Auto-DevOps template
  • Job definition example
  • CI Templates
• Ensure the report version matches the equivalent schema version
• Conforms to the code review guidelines
• Conforms to the Go guidelines
• Security reports checked/validated by reviewer