The resignation comes almost three years after Bill and Melinda Gates announced their divorce in May 2021