Sir Brian May has resigned as the RSPCA’s vice president over what he called “appalling” animal welfare standards in farms certified under its scheme.