Charles Este (1696–1745), Bishop of Waterford