The issue is that the subpoena told Twitter/X not to inform the accountholder that their information was going to be given to the NYPD, nor inform the accountholder of the subpoena's existence. While that's enforceable with a warrant, it is not enforceable with a subpoena.
This shows how NYPD is attempting to compel companies to provide them with personal information of users, and keep it secret from the users, all without needing a judge's approval or warrant. That is not the proper channel to do this, and they know they have no legal leg to stand on which is why they aren't going to try to fight it's legitimacy in court.