Isn't Zhuge Liang's military talent inferior even to Wei Yan's?

‌Even if Zhuge Liang was good at internal administration,
he lacked military achievements..
I feel it would have been better
if they had instead appointed Wei Yan
as the commander-in-chief of the Northern Expeditions;