A prominent Queensland health executive has been sensationally sacked amid the state’s hospital overcrowding crisis.