Residents have been left devastated after a controversial new quarry spanning more than 25 hectares was given the green light.