It's a "Marmite" tune: people seem to either love it or loathe it. I'm in the love it group, and it was a favourite of both of my parents, who lived in Aberdeenshire, so a recorded version was played at both of their funerals. I went through about 100 different versions on iTunes to find the "right" one, which was, appropriately enough, the Grampian Police Pipe Band's recording. Some of the others were absolutely dire, with electronic instruments, rock band drumming, etc.
The Andre Rieu version in the link was stirring, but too symphonic for me, just as the sung versions tend to be done by big operatic choirs and not by any folk singer I've ever heard. (Ok, I did surprise them all once in a session in England when assembled company played the tune, and I then launched into singing it - just happened to have the words with me! "Oh, we never knew there were words" they said!)
It does often get played at rugby internationals, but by pipe bands, and not sung. I remember being at one match, in the West Stand at Murrayfield: looking across the pitch, there's a gap between the top of the East stand and the roof, through which I could see the whole Edinburgh skyline while the pipe band played - now that I did find stirring!