Forget the sneering of Benjamin Britten, for whom Brahms’s music was “ugly and foul”, the German composer and pianist was a virtuoso talent whose best works burn with volcanic passion and seriousness of purpose