One way to think about intuitively why there aren't a fininte number of non-trivial zeroes of $\zeta$ is that, if there were, then it would grow in a way that we know it doesn't. To show this, we use the completed zeta fucntion, which is defined as:
$$\xi = \begin{cases}
s \left({s - 1}\right) \pi^{-s/2} \Gamma \left({\frac s 2}\right) \zeta \left({s}\right) & : \Re \left({s}\right) > 0 \\
\xi \left({1 - s}\right) & : \Re \left({s}\right) \le 0
\end{cases}$$
Some authors use a constant factor of $\frac12$ in this definition and others don't. It doesn't really matter. This is incredibly helpful, because we can ignore all of the trivial zeros, of $\zeta$, leaving only the non-trivial ones, because we know $\zeta(s) > 0$ for $\Re(s) > 1$ and the same obviously applies for the other factors of this function. The second part of this definition is incredibly useful as well, because we have by the same argument that $\xi >0$ for all $s$ with real part less than $0$. We therefore see that all trivial zeroes of the zeta function are not zeros of our new completed function, while all of the non-trivial zeroes are. Since other than poles at $0,1$ $\xi$ is non-vanishing where $\zeta$ is, we have that the statement: "there are an infinite number of nontrivial zeros to $\zeta$" is equivalent to "there are an infinite number of zeros for $\xi$ of any type."This already may seem overly abstract and distant from the problem, but we really are just looking at a completion of the same function, that isn't $0$ where we don't want it to be.
It can be shown, with a little difficulty concerning the order of $\xi$, by the Hadamard factorisation theorem that
$$\xi(s) = \prod_\rho\left(1-\frac s\rho\right)$$
for its zeros $\rho$. This is a little trickly analytically, but the intuition is basically the same as that for the Weierstass factorization theorem. Plus, it's on Wikipedia. Now, if this function had a finite number of zeros, it would be a polynomial of degree, say $n$. But we know that asymptotically for a polynomial $P(x)$ that $\log(P(x)) \sim n\log(s)$ on the real line. This goes against what we know about $\zeta$, which gives that on $\Bbb{R}$ we have that $\log(\xi(s))\sim s\log (s).$ Therefore $\xi$ has an infinite number of zeros and $\zeta$ has an infinite number of non-trivial zeros.
I glossed over a really important point, which is that you can apply the factorisation theorem, and that you can arrive at the formula I gave. This wouldn't really assist much with intuition, however, as those parts are a little technical. You would be well off learning them though.
In the end, functions with finite order and with a finite number of zeros behave in a very particular way, and we know for certain that $\xi$ doesn't behave in this way. This $\xi$ contains information about the non-trivial zeros of $\zeta$, and the fact that it has an infinite number of zeros is enough to prove our claim.