Stability of superconducting resonators: Motional narrowing and the role of Landau-Zener driving of two-level defects