Prime Minister Keir Starmer thanks McSweeney for his "dedication, loyalty and leadership", as Conservative leader Kemi Badenoch says his resignation is "about time".