I think the key intuition to think of here is a situation where you are interested in modelling a single outcome of interest, $Y$, with three possible independent variables, $W$, $X$, $Z$. Imagine in a standard regression, $W$ and $X$ are found significant whereas the coefficient on $Z$ is found insignificant and close to zero, although $Z$ and $Y$ are correlated one-on-one.
Let's assume the reason that $Z$ is not significant in the full regression is because all the effect of $Z$ is subsumed in $W$ and $X$ (i.e. they jointly form a better predictor). Now in a ridge regression context, for some parameter values of $\lambda$ it might be the case that using $Z$ is preferred over having both $W$ and $X$ due to the inclusion of a parameter error term.
This example is also illustrative why ridge regression is used less within an inferential context, because even when controlling for potential confounders, they might still be 'the last coefficient standing'.
See below an example of an outcome $Y$ which is solely related to two variables, $Z$ and $X$. The variable $W$ is affected by both $Z$ and $X$ but does not affect $Y$. Therefore, the SSE (which is minimised in the regression contex) is much lower in a regression of the form $y_i = \beta_0 + \beta_x X + \beta_z Z + \beta_w W + u_i$ relative to one with only $W$: $y_i = \beta_0 + \beta_w W + u_i$.
This is illustrated in the R-squared of the former (at 0.97) relative to the latter (at 0.35). However, the L1-norm is strictly higher in the former case than in the latter (namely $L_1 = \sqrt{\beta_0^2 + \beta_1^2 + \beta_2^2}$). As you drive up $\lambda$, the model will prioritise minimising the $L_1$-norm over the SSE. At some point, the model will prefer having just a single non-zero $\beta$ driving the $L_1$-norm, even at the cost of a much poorer model fit. Therefore, you can see that the coefficients on $\beta_x$ and $\beta_z$ start to decrease up to the point that only $\beta_w$ is non-zero. Also note that further increasing $\lambda$ makes the $L_1$-norm important enough to completely lose interest in minimising any SSE (and therefore generating any model fit) and drives all coefficients to zero.

library(glmnet)
x <- rnorm(100, 10, 2)
z <- rnorm(100, 5, 2)
w <- 0.8*x + 0.8*z + rnorm(100, 0, 1)
u <- rnorm(100, 0, 1)
y <- 2*x + 2*z + u
# R-squared of 0.97
summary(lm(y ~ 1 + x + z + w))
# R-squared of 0.35
summary(lm(y ~ 1 + z))
fit <- glmnet(as.matrix(cbind(x, z, w)), as.matrix(y))
plot(fit)