> I just assume there is a cognitive dissonance and their talents are valuable even if I can't see how.

I think that's the right attitude. Even if you look down upon SEO, there's no denying that the guy learned a skill that took time and effort, plus took some risks that it wouldn't work out.