Update sharding key and schema for zoekt_nodes

What does this MR do and why?

Related to #442665 (closed)

zoekt_nodes contain cell specific data (location of the zoekt node servers) and does not contain customer data.

Update the schema and add sharding key exemption to YAML doc per guidelines

Update sharding key spec to not check exempt tables

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

N/A

How to set up and validate locally

N/A