For simplicity, suppose we are dealing with an absolutely continuous distribution with density function $f_X$ with some corresponding non-negative kernel function $g_X \propto f_X$. Suppose we consider the general $k$th absolute moment, which is given by the following integral expressions:
$$\mathbb{E}(|X^k|)
= \int \limits_\mathbb{R} |x|^k f_X(x) \ dx
= \frac{\int_\mathbb{R} |x|^k g_X(x) \ dx}{\int_\mathbb{R} g_X(x) \ dx}.$$
Broadly speaking, this integral will be finite so long as the "tails" of $g_X$ decrease fast enough relative to the growth of $|x^k|$ that their product (i.e., the integrand) yields a finite integral when taken over the whole set of real numbers. (For the specific condition required in the tails, see the analysis below.)
The norming axiom of probability theory requires that the above integral is one when $k=0$, and this means that the tails of the kernel function $g_X$ integrates to a finite positive number. This imposes a requirement on how fast the tails of the kernel function decrease to zero. However, it is possible for the tails of the kernel function $g_X$ to decrease fast enough to ensure that $\int_\mathbb{R} g_X(x) \ dx$ is finite, but not fast enough to ensure that $\int_\mathbb{R} |x|^k g_X(x) \ dx$ is finite for some $k>0$. When this happens, the above integral is infinite, and you get moments that do not exist.
Summing this up in intuitive terms, the reason you can have distributions with moments that don't exist is that probability theory imposes only weak requirements on the rate at which the tails of a distribution decrease to zero. The norming axiom imposes a weak condition that requires the tails to decrease to zero fast enough for the integral of the density to exist, but this does not impose any requirement that the integral of the density multiplied by a positive power function must exist.
Sufficient condition for finite limit: A sufficient condition for a finite integral is $g_X(x) = \mathcal{O}(|x|^{-(k+1+\varepsilon)})$ for some $\varepsilon > 0$. This condition ensures that the kernel function (and thus also the density function) decreases fast enough in its tails to yield a finite integral (see explanation of Big-O notation here). To see why this condition is sufficient, suppose the condition holds and denote the corresponding limit supremum:
$$K \equiv \limsup_{|x| \rightarrow \infty} \Bigg| \frac{f_X(x)}{|x|^{k+1+\varepsilon}} \Bigg|.$$
The condition stated here ensures that $K < \infty$ and we then have:
$$\begin{align}
\mathbb{E}(|X^k|)
&= \int \limits_\mathbb{R} |x|^k f_X(x) \ dx \\[6pt]
&= \int \limits_{-1}^1 |x|^k f_X(x) \ dx + \int \limits_\mathbb{R} |x|^k f_X(x) \cdot \mathbb{I}(|x| \geqslant 1) \ dx \\[6pt]
&\leqslant 2 + \int \limits_\mathbb{R} |x|^k f_X(x) \cdot \mathbb{I}(|x| \geqslant 1) \ dx \\[6pt]
&= 2 + \int \limits_\mathbb{R} |x|^k \mathcal{O}(|x|^{-(k+1+\varepsilon)}) \cdot \mathbb{I}(|x| \geqslant 1) \ dx \\[6pt]
&= 2 + \int \limits_\mathbb{R} \frac{\mathcal{O}(1)}{|x|^{1+\varepsilon}} \cdot \mathbb{I}(|x| \geqslant 1) \ dx \\[6pt]
&\leqslant 2 + K \times \int \limits_\mathbb{R} \frac{1}{|x|^{1+\varepsilon}} \cdot \mathbb{I}(|x| \geqslant 1) \ dx \\[6pt]
&= 2 + K \times 2 \int \limits_1^\infty \frac{1}{x^{1+\varepsilon}} \ dx \\[6pt]
&= 2 + K \times 2 \Bigg[ - \frac{1}{\varepsilon x^{\varepsilon}} \Bigg]_{x=1}^{x \rightarrow \infty} \\[6pt]
&= K \times 2 \Bigg[ 0 - - \frac{1}{\varepsilon} \Bigg]_{x=1}^{x \rightarrow \infty} \\[6pt]
&= K \times \frac{2}{\varepsilon} < \infty, \\[6pt]
\end{align}$$
which establishes that the integral is finite. (Note that the weaker condition $g_X(x) = \mathcal{O}(|x|^{-(k+1)})$ is not sufficient for this result.)