Gardaí found Aaron Wolfe (32) in a highly intoxicated state, stripped to the waist, with his hands covered in blood