Could The Rock's next opponent be Henry Cavill? Well, it won't be anytime soon, but Dwayne Johnson sure seems up for it.
Black Adam is more than able to stand up to Superman - with nearly identical strength and speed, Adam's powers are also derived from magic, which Superman is traditionally nearly as weak to as Kryptonite.
First, though, The Rock will suit up as Black Adam and fight Shazam in Shazam, currently scheduled for April 5, 2019. Of course, he'll need someone to fight in that movie, and that role hasn't been cast yet.