Father Frank Brennan calls on Catholic Church to again consider female priests as he prepares to leave Canberra