(#22910) Use memory storeconfigs backend

Previously, the test would only pass if you had activerecord installed,
which it won't be when doing `bundle install --without development extra`

Since the test is exercising the storeconfig terminus, we can use a
memory-based storeconfig-backend, as is done for the shared examples.