Hi Nanaba
The general result is that the fewer the number of moments that exist (ie are finite), then the heavier the tail of the distribution. The paragraphs are consistent with each other, both stating this result. Perhaps the confusion is around the statement that the higher moments are infinite? This is what is being referred to in the second paragraph when it is stated that not all moments exist (ie not all are finite).
So, for example, all the moments are finite for the exponential distribution, which we can think of as having a lighter tail. Not all moments are finite for the Pareto distribution, as per the second paragraph, and so we can think of this distribution as having a heavier tail.
This is all to do with how we calculate the moments, consider a distribution defined for x > 0:
\( E[X^k] = \int_{0}^{\infty} x^k f_X(x) dx \)
As we consider larger and larger values of k, x^k gets larger and larger as x gets larger in magnitude. If \(f_X(x)\) doesn't decrease down towards 0 quickly enough as x gets larger to offset this, then the integral won't converge and moments won't exist past a certain value of k.
If the pdf drops down towards 0 quickly enough, then all the moments exist, as is the case for the exponential distribution.
Hope this helps!
Andy