KASHz+SUPER: Evidence of cold molecular gas depletion in AGN hosts at cosmic noon