Sir John Norris (1670/1671–1749), Admiral of the Fleet