Stop writing into ci_pipeline_variables
## Context
Partitions of `p_ci_pipeline_variables` take a lot of space. Our ultimate goal is to offload pipeline variables to object storage so we can eventually drop `p_ci_pipeline_variables`.
Before dropping the table, one of the first steps is to ensure we're no longer writing data to it.
## Proposal
Follow the approach in the POC MR (https://gitlab.com/gitlab-org/gitlab/-/merge_requests/218525) to implement a feature flag to turn off writes to `p_ci_pipeline_variables` when appropriate.
The logic to stop writing to the table is relatively small. The bulk of the work here will be adding full test coverage and ensuring that our existing tests don't break.
issue