I'll try to give an intuitive explanation.
The t-statistic* has a numerator and a denominator. For example, the statistic in the one sample t-test is
$$\frac{\bar{x}-\mu_0}{s/\sqrt{n}}$$
*(there are several, but this discussion should hopefully be general enough to cover the ones you are asking about)
Under the assumptions, the numerator has a normal distribution with mean 0 and some unknown standard deviation.
Under the same set of assumptions, the denominator is an estimate of the standard deviation of the distribution of the numerator (the standard error of the statistic on the numerator). It is independent of the numerator. Its square is a chi-square random variable divided by its degrees of freedom (which is also the d.f. of the t-distribution) times the square of $\sigma_\text{numerator}$.
When the degrees of freedom are small, the denominator tends to be fairly right-skew. It has a high chance of being less than its mean, and a relatively good chance of being quite small. At the same time, it also has some chance of being much, much larger than its mean.
Under the assumption of normality, the numerator and denominator are independent. So if we draw randomly from the distribution of this t-statistic we have a normal random number divided by a second randomly* chosen value from a right-skew distribution that's on average around 1.
* without regard to the normal term
Because it's on the denominator, the small values in the distribution of the denominator produce very large t-values. The right-skew in the denominator make the t-statistic heavy-tailed. The right tail of the distribution, when on the denominator makes the t-distribution more sharply peaked than a normal with the same standard deviation as the t.
However, as the degrees of freedom become large, the distribution becomes much more normal-looking and much more "tight" around its mean.
As such, the effect of dividing by the denominator on the shape of the distribution of the numerator reduces as the degrees of freedom increase.
Eventually - as Slutsky's theorem might suggest to us could happen - the effect of the denominator becomes more like dividing by a constant and the distribution of the t-statistic is very close to normal.
Considered in terms of the reciprocal of the denominator
whuber suggested in comments that it might be more illuminating to look at the reciprocal of the denominator. That is, we could write our t-statistics as numerator (normal) times reciprocal-of-denominator (right-skew).
For example, our one-sample-t statistic above would become:
$${\sqrt{n}(\bar{x}-\mu_0)}\cdot{1/s}$$
Now consider the population standard deviation of the original $X_i$, $\sigma_x$. We can multiply and divide by it, like so:
$${\sqrt{n}(\bar{x}-\mu_0)/\sigma_x}\cdot{\sigma_x/s}$$
The first term is standard normal. The second term (the square root of a scaled inverse-chi-squared random variable) then scales that standard normal by values that are either larger or smaller than 1, "spreading it out".
Under the assumption of normality, the two terms in the product are independent. So if we draw randomly from the distribution of this t-statistic we have a normal random number (the first term in the product) times a second randomly-chosen value (without regard to the normal term) from a right-skew distribution that's 'typically' around 1.
When the d.f. are large, the value tends to be very close to 1, but when the df are small, it's quite skew and the spread is large, with the big right tail of this scaling factor making the tail quite fat: