Connolly opens up about alcohol addiction issues that has plagued his career