Blueprint executor: Multinode clickhouse deployment acts on expunged zones

I know you're just moving this - but should this disposition be `is_in_service`? Why is `any` acceptable here?

_Originally posted by @smklein in https://github.com/oxidecomputer/omicron/pull/7722#discussion_r1979912998_
            