Why does my opamp circuit give only x10 overall gain
The impedance of your 100pF coupling capacitor is too high at 5MHz (about 318 ohms). 
in comparison to the 52 ohm resistor. 

The total impedance of the series combination is about 322 ohms (they add in quadrature) so you're getting an ideal gain of 1.58 from the first stage and 10 from the second stage.