NSW’s highest-profile arts bureaucrat has resigned and will now lead the state’s flagship museum of historic homes and archives, capping a month of turmoil in the state’s cultural sector.