Much is needed to tackle Cardiff's binge drinking reputation, according to a leading academic.