Brennan will miss AFLW grand final after her appeal was dismissed