To facilitate analysis, denote the rate-of-change of $S$ over the interval $[t,t+\Delta]$ as:
$$S'_\Delta(t) \equiv \frac{S(t+\Delta) - S(t)}{\Delta},$$
and observe that this rate-of-change becomes the derivative $S'(t)$ as $\Delta \downarrow 0$. Now, conditional on surviving up to time $t$, the probability of failure within a period $\Delta > 0$, expressed as a rate over that period, is given by:
$$\begin{align} \frac{\mathbb{P}(t < T \leqslant t+\Delta | T > t)}{\Delta} &= \frac{1}{\Delta} \frac{\mathbb{P}(t < T \leqslant t+\Delta)}{\mathbb{P}(T > t)} \\[6pt] &= \frac{1}{\Delta} \frac{S(t) - S(t+\Delta)}{S(t)} \\[6pt] &= - \frac{1}{\Delta} \frac{S(t+\Delta) - S(t)}{S(t)} \\[6pt] &= - \frac{1}{S(t)} \frac{S(t+\Delta) - S(t)}{\Delta} \\[6pt] &= - \frac{S'_\Delta(t)}{S(t)} \\[6pt] &\approx - \frac{S'(t)}{S(t)} \\[6pt] &= - \frac{d}{dt} \log(S(t)). \\[6pt] \end{align}$$
Taking $\Delta \downarrow 0$ then makes this approximation exact and you have the hazard function at time $t$. As to the intuition of this result, it mostly comes from the fact that the conditioning in the probability gives a denominator $S(t)$, which is the term that leads to the logarithmic derivative.