Dwayne 'The Rock' Johnson praised for delivering passionate opening speech at Super Bowl LVI