Thomas Herbert (1656–1733), 8th Earl of Pembroke, Lord-Lieutenant of Monmouthshire and Attorney General to Charles II