Make of it what you will but the law is clear - since this is a matter of Presidential digression (and as such a foreign policy plank), he and he alone decides, unless Congress rewrites the law and he signs it - unlikely. National security also falls under the President’s authority. The States long ago ceded their authority to override a Presidential decision - see US Civil War.
We did not accept NAZIs or Italians or Japanese. We cannot accept these ‘Syrians.’