Revert all rule removals

What does this MR do?

Reverts all the rule removals that have not yet been deployed to semgrep.

Reverted MRs:

• !193 (merged)
• !198 (merged)
• !199 (merged)
• !197 (merged)
• !194 (merged)
• !188 (merged)

This MR also cherry-picks the fix applied in https://gitlab.com/gitlab-org/security-products/sast-rules/-/tags/v1.3.30+2

What are the related issue numbers?

gitlab-org/gitlab#424817 (closed)