Harris County Sheriff Ed Gonzalez said Charles Storey was in the midst of a drinking binge when the shooting occurred