Andoo Team Australia led from start to finish to win the last race of the semi-final but missed a spot in the two-boat final