It's hard to have any sympathy for the Ancients since almost all of them act like arrogant dicks. That's my question to the writers, why did they have them act like that?
Because they're human. Ancients taking advice from Rodney would be like a modern human taking a advice from a cave man, times 1000+. Of course they believed they knew better, just as we would.