Resolve "Stub Snowplow before all specs"

What does this MR do and why?

This MR aims to enable snowplow by default for rspecs. Related to #345488 (closed), #348200 (closed)

Describe in detail what your merge request does and why.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

1. Any Rspec (especially with Snowplow-related test cases) should succeed without the :snowplow metadata.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #348200 (closed)