Updates to the storage CRs

This updates drain and delete storage CRs so they reference each other, and also updates some queries to make it nicer for multiple nodes. These changes came out of the first deletion run in https://gitlab.com/gitlab-com/gl-infra/production/-/issues/17098