The gunman branded the fatal shooting at the Lighthouse pub 'f***ing stupid, pointless and a waste of a life'