Rory McIlroy let his frustrations boil over with a foul-mouthed outburst during his final round at the US Open