Double-averaging can fail to characterize the long-term evolution of Lidov–Kozai Cycles and derivation of an analytical correction