The politician who led the charge to impeach Brazil's former President Dilma Rousseff has himself been ousted from power.