Hi.
When Riemann introduced his zeta function, he started to explore its properties and found many new interesting zeta function features. For instance, he could tell zeta is infinite at point 1, and he could tell that zeta vanishes at negative even integers. So those first and obvious facts are called "obvious" or "trivial".
Then Riemann and other mathematicians continued to explore properties of zeta function. They found that zeta is connected to number of primes. They were able to show that number of primes \pi(x) is
\pi(x)=Li(x) + \mathcal{O}
We know everything there is to know about function Li(x). But what do we know about \mathcal{O}? Well, we know that
\mathcal{O}=\sum_{\rho} \frac{x^\rho}{\rho}
Here sum ranges all over zeta function zeros \rho that are not "obvious" or "trivial". We do not know a lot about these not-so-obvious zeros \rho. And yet, we need those not-obvious zeros in order to calculate number of primes less than x as exactly as possible. These not-obvious and yet misterious zeta zeros are called non-trivial.
All non-trivial zeta function zeros are inside a critical strip. Complex plane is like a big sheet, and critical strip is like an infinitely long ribbon in it. Critical strip stretches infinitely up and down, but is not very wide. Critical strip is confined between 0 and 1 horizontally, and stretches ad infinitum vertically.
Riemann hypothesis is that all non-trivial zeros are on critical line. Critical line is exactly in the middle of critical strip.
We know how to calculate location of non-trivial zeros on critical line. The formula to calculate position of non-trivial zeros on critical line is long known. It's name is Rieman-Siegel formula. Siegel was a mathematician who happened to have read Riemann's scribblings long after Riemann died. Reading Riemann's notes, Siegel found an interesting equation. He played with that newly discovered equation, and found Riemann-Siegel formula. So we can calculate location of zeros we need to know in order to calculate number of primes \pi(x).
So, how many zero locations we have to calculate? How many zeros are there in critical strip?
Well... Infinitely many. And we don't really know much about them.
So, in order to calculate number of primes between 1 and 2, or number of primes between 1 and 10000000000000000000000000000000000000000, our formula tells us to do a sum over all infinitely many non-trivial zeros we know nothing about?
Yes.
And this is how primes and zeta function zeros are connected.
So what's the use of Riemann zeta function if we do not know much about it anyway?
Well, we know nothing much about primes at all. However, we do know something about Riemann zeta function: we know how to calculate zeta function if only we have powerful computers. So, we can calculate Riemann zeta function. And Riemann showed that zeta function is connected to primes. This means that we can also calculate primes now. That's why is Riemann zeta function such a blast. It enables us to calculate number of primes we couldn't really calculate before Riemann.
So, what happens if there are zeros off critical line?
Several unpleasant things happen then. First: calculations become harder now. Second: there are huge gaps between large primes then, empty spaces without primes stretching almost infinitely. If Riemann hypothesis holds, then primes appear more regularly, and "there is music in primes".
Will the universe end if Riemann hypothesis is false? No. Will economy collapse? No. Will anything happen at all? Yes. If RH stands, many many theorems in analytic number theory will come to life, and number theory will flourish. If RH is false, then... theorems will die and number theory will become dead. For a long, long time to come...
I hope this explained it a bit.
Cheers.