That is the usual way of looking at the R^2 in a OLS context, yes. However, the R^2 is invariant to a rotation of the design matrix X, so we can utilize its QR decomposition to go from
y_hat = X * beta = (QR) * beta = Q * (R * beta) = Q * theta
where theta = R * beta. So, you can think of this as a regression of y on Q and then beta = R^{-1} * theta is a generated quantity.
Okay, so what is the prior distribution on theta, the vector of coefficients for Q? Since Q'Q = I, theta_k can be conceptualized as the correlation between y and the k-th column of Q multiplied by the standard deviation of y, divided by the standard deviation of the k-th column of Q which is the square root of N - 1.
That pushes back the question to what is your prior on the correlations between y and the columns of Q? Here we make the assumption that this vector of correlations has a spherical distribution, which can be represented as \sqrt{R^2} * u, where u is uniformally distributed on the surface of a hypersphere. Since u'u = 1, the sum-of-squared correlations is R^2, which is the proportion of variance in the outcome attributable to the predictors in a linear model.
And that brings us to the question, what is your prior on R^2? The LKJ paper implies that if you have a correlation matrix among both the predictors and the outcome, the distribution of the R^2 is beta with shape parameters K / 2 and eta. So, in principle, a user would need to choose eta to reflect their subjective beliefs about the R^2. However, the R2() function that is called by stan_lm() reverses this around and asks what do you think the prior mode / mean / median / log-expectation of the R^2 is? Given the answer to that question, it can solve for the implied value of eta.
All together, the primitive parameters are R^2, u, and sigma_y (the
marginal standard deviation of Y). Since sigma_y is a scale parameter and not of much interest, it is given a Jeffreys' prior, which is uniform on the log scale. Given these three things (and the fixed R), we can calculate beta and sigma (the
conditional standard deviation of Y) as generated or intermediate quantities, where sigma = sigma_y * sqrt(1 - R^2).
So, in summary, this is really just a way of eliciting an informative prior on the R^2 that happens to imply a pretty reasonable set of joint prior beliefs about beta (it's centered at the origin, has fat tails, is round at the mode, etc.). Consequently, relative to OLS the posterior medians will usually be shrunk toward zero a bit, which is usually a good thing for out-of-sample predictions.