I have read multiple definitions so far but something is not clicking.
My most naive understanding is that $|G:H|$ is a "number" (could be infinite) that represents how many times $H$ is in $G$.
But even this doesn't seem fully correct.
I would like a general non-formal explanation and perhaps an example to understand the intuition.
Upgrading my comment to an answer:
You have the right intuition, but I would word it slightly differently.
$|G:H|$ is the number of (left or right) cosets of $H$. A coset is not a copy of $H$; indeed, a coset of $H$ isn't even a subgroup unless it's $H$ itself.
It would be more correct to call the coset $aH$ a translate of $H$ by the element $a$. Distinct cosets are disjoint and form a partition of $G$. So one might say that the cosets of $H$ constitute a "tiling" of $G$, and $|G:H|$ is the number of tiles.
To take a concrete example, let $G$ be the additive group of integers modulo $12$, and let $H$ be the subgroup generated by $4$, so $H = \{0, 4, 8\}$. Then there are four distinct cosets of $H$, namely: $$\begin{aligned} H &= \{0, 4, 8\} \\ 1+H &= \{1, 5, 9\} \\ 2+H &= \{2, 6, 10\} \\ 3+H &= \{3, 7, 11\} \\ \end{aligned}$$ In other words, the cosets are $H$ and its translates $1+H$, $2+H$, and $3+H$.
Together these four cosets contain all the elements of $G$, so they constitute a partition (tiling) of $G$. The number of tiles is the number of cosets, which is $|G:H| = |G|/|H| = 12/3 = 4$.