Introduce `skip_live_env` RSpec meta and add it to tests

What does this MR do?

Introduces skip_live_env RSpec meta and add it to tests

Closes https://gitlab.com/gitlab-org/quality/team-tasks/-/issues/493

Conformity

• [-] Changelog entry
• [-] Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• [-] Database guides
• [-] Separation of EE specific content