The council's Labour leadership were forced to consider a future outside the Greater Manchester housing plan