Make sure sharding_key_spec_helpers filters out unvalidated NOT NULL constraints

sharding_key_spec_helpers currently considers tables with unvalidated NOT NULL constraints as having NOT NULL. We should update the logic to filter those out.