Wade strikes me as a kind of twangy "hick" name. Like
Cletus or
Orville. Not very elegant, but fun in its own way. Although like
Ari I am also not surprised that it's not more popular.
I think
Scarlett O'Hara named her first kid this in the novel, because during the Civil War it was fashionable for Southerners to name their sons after the leader of the regiment their fathers were serving in. So
Melanie named her son
Beau, and
Scarlett was stuck with "
Wade Hampton
Hamilton".