Every CLT is basically a rendering of the fact that "many" "not-too-large" and "not-too-correlated" random increments average out in a bell shape. All three conditions ("many", "not-too-large", "not-too-correlated") are important. Lyapunov condition is one way of quantifying the "not-too-large increments" condition.

Naturally each random variable $Y_k$ may be unbounded hence the condition bears on their moments. Lyapunov showed that some averaged control on some $(2+\delta)$-moment was enough to guarantee the conclusion. "Averaged" is good here since it allows for some exceptionally large individual $(2+\delta)$-moments. Uniform $(2+\delta)$-integrability is more restrictive, and some variants of the CLT weaken this condition.

The fact that a "not-too-large increments" condition of some sort is required should not come as a surprise, the idea being that if the size of some increment is not negligible then its realization might influence noticeably the result.


This is linked to Lindeberg condition, namely, for each positive $\varepsilon$, $$\frac 1{s_n^2}\sum_{k=1}^n\int_{\{|X_k|\geqslant \varepsilon s_n\}}X_k^2\mathrm d\mathbb P\to 0.$$ We can prove the central limit theorem checking that $\mathbb E\left[f\left(\frac{S_n}{s_n}\right)\right]\to \mathbb E[f\left(N\right)]$, where $N\sim N(0,1)$, only for a class $f$ of smooth bounded functions. In particular, we don't need to to the test for all continuous bounded functions. Then with this idea in mind, we can use Taylor's formula and Lindeberg condition to control the remainder.

Now, if we are in the more favorable case in which we have moments of order $2+\delta$ for some positive $\delta$, then Lyapunov's condition $$\frac 1{s_n^{2+\delta}}\sum_{k=1}^n\mathbb E\left[|X_k|^{2+\delta}\right]\to 0$$ implies Lindeberg's one, and is easier to check.