For the intuition you can imagine the signal from your favorite radio station that you receive in your car. That's the variable. Sometimes the weather isn't good and then the signal is disturbed such that you hear noise during the song and the bigger the disturbance the more noise will interfere with your song until you may not even hear it anymore.
The same can happen with variables if they are misreported as in household surveys, among others. Whenever you have self-reported or non-administrative data this is a worry. Suppose you want to regress
$$Y_i = \alpha + \beta X_i + \epsilon_i$$
but you observe $\tilde{X}_i = X_i + \eta_i$ because you were sleepy when you entered the data in your datasheet and every now and then you made a mistake in entering the data. This adds the "noise" we were talking about before. This is represented by $\eta_i$ here. Let's say that you made this sleepiness error at random so it is uncorrelated with $X_i$ and $\epsilon_i$. If you then regress
$$Y_i = \alpha + \beta \tilde{X}_i + u_i$$
with $u_i = \epsilon_i - \beta \eta_i$, you know that your estimated coefficient is
$$\begin{align}
\widehat{\beta} &= \frac{Cov(Y_i,\tilde{X}_i)}{Var(\tilde{X}_i)} \\
&= \frac{Cov(\alpha + \beta \tilde{X}_i + u_i,\tilde{X}_i)}{Var(\tilde{X}_i)} \\
&= \beta + \frac{Cov(u_i,\tilde{X}_i)}{Var(X_i + \eta_i)} \\
&= \beta + \frac{Cov(\epsilon_i -\beta \eta_i , X_i + \eta_i)}{Var(X_i + \eta_i)} \\
&= \beta \left(1 - \frac{Var(\eta_i)}{{Var(X_i + \eta_i)}} \right)
\end{align}
$$
The second line expands $Y_i$. The third line splits the covariance into the sum of covariances, the fourth line uses the definitions of $u_i$ and $\tilde{X}_i$. Then use the fact that $\eta_i$ is uncorrelated with $X_i$ and $\epsilon_i$. The last line factors. In the bracket of the last line you have one minus the inverse of the signal-to-noise ratio.
The bigger the noise becomes relative to the signal the worse will be the song in your radio. The signal-to-noise ratio lies between 0 and 1, so if there is only noise you will not hear the song anymore. This is the so-called attenuation bias of your estimated $\widehat{\beta}$ due to the measurement error.
With regards to whuber's comment that you need a very strong noise in order to affect the results: in panel data methods the attenuation bias is propagated (see Griliches and Hausman, 1986). For example, if somebody reports a 9 dollars hourly wage in year 1 when in reality she gets 10 dollars then this is just an error of 10% for OLS. Now if she gets 12 dollars in year 2 (suppose now you have a panel data set) and you want to take advantage of the panel structure by first differencing, your first difference is $12 - 9 = 3$ but in reality it should have been $12 - 10 = 2$. So now the measurment error has increased to a half.