The British Beer & Pub Association (BBPA) has said it is "extremely disappointed" after the UK's advertising authorities dismissed complaints about an "alarmist" ad linking alcohol consumption to cancer.