The retired all-rounder was on a fishing trip with his former Australian cricket rival when he tripped and fell from a boat