Unions and campaigners condemn Home Secretary after government confirms scrapping of care worker visas