Rodney has no idea what that pod contained no more than he knows what the asgard core contains. all he knows are that the pod race is "highly advanced". so what. the asgard, the nox, the tollans, even the tokra & goauld also qualify as highly advanced
McKay's reaction was perfectly normal, his is simply "the more the merrier". this was a new race with new tech. different races each have their strongpoints. asgards were very good at shields & weapons but sux0red at medicine for instance. the goauld on the other hand had highly advanced medical tech (which they stole from the ancients, granted). etc.
his statement doesn't imply any kind of superiority of this new race over the other known ones
besides it's not like the terrans actually possess asgard tech. they can build & replicate it thanks to its built-in AI & step-by-step instructions but they still have no idea how any of it actually works (they still need the core)
kinda like a kid assembling a lego (also remember how those slaves in the ori galaxy were assembling all those uber-advanced ships ?)
edit> heck it took Sam 50 years just to figure out how to reverse time using an already existing time dilation device, even with help from holo-Thor. looks like that knowledge in the asgard core ain't as easy to "process" after all eh ?
it's clear that terrans will only learn to dispense with the asgard core in a distant future. Mckay probably saw in that pod an opportunity to acquire new tech quickly