Since the title of your question is regarding the "Rationale behind using the T-Distribution", I will (attempt) to answer in broad terms and only go into specifics if necessary.
The overall answer is that the T-Distribution gives a higher probability to extreme events, given a small sample size. The reasoning behind this is intuitive in that, as you can imagine, if you have relatively small sample from a population, there is a higher probability that an extreme event from the population did not "make it" into your sample. On the other hand, if you have a relatively large sample from the same population, the probability that an extreme event did not "make it" into your sample is lower, since your sample is capturing more of that population.
Visually, the T-distribution looks like a Normal Distribution with a slightly lower "peak" and slightly "fatter" tails. In this picture, the Normal Distribution is the blue density and the T-Distribution is the red.
The term "small" is relative, although generally speaking is relates to samples where $N\leq30$. However, the T-Distribution is defined in terms of Degrees of Freedom, where $\textrm{degrees of freedom} = N-1$. This is where the intuition of the T-Distribution approaching the Normal Distribution as $N$ increases comes from.
Since $N$ is our denominator in calculating the mean, variance, etc, replacing the $N$ with $N~-1$ will have a larger effect when $N$ is small. For example:
- Given a sample where $N~=~30$, the difference between the mean using $\frac{\sum_{i=1}^{30} x_i}{30}$ and the mean using $\frac{\sum_{i=1}^{29} x_i}{29}$ will be a lot greater than,
- Given a sample where $N~=~10,000$, the difference between the mean using $\frac{\sum_{i=1}^{10,000} x_i}{10,000}$ and the mean using $\frac{\sum_{i=1}^{9,999} x_i}{9,999}$.
So, pulling back from the math to the visual representation, as $N$ increases, the T-Distribution will asymptotically approach the Normal Distrubtion, since the negative one (-1) in the definition of degrees of freedom has a ever decreasing effect as $N$ increases.
Using statistical terms, the T-Distribution allows your estimate to be unbiased when using a small sample, meaning the estimated statistic from your sample will be closer to the population statistic you are trying to estimate.