Queensland MP Darren Zanow has been diagnosed with an incurable brain disease, forcing him to resign at this year's state election just months after winning his seat at a by-election.