It is common to talk about the linear correlation, Pearson's $r$, between two random variables $\{(x_1,y_1),(x_2,y_2),\ldots,(x_n,y_n)\}$ as having two components: a) the copula and b) the marginal distributions of $x$ and $y$. In contrast, the rank correlation, Spearman's $\rho$, depends only on the copula.
As a reminder, the calculation of $r$ and $\rho$ are identical except that in the case of $\rho$, the variables are first transformed to ordered ranks $R(.) = 1,2,\ldots, n$.
$$r = \frac{\operatorname{Cov}(x_i,y_i)}{\sqrt{\operatorname{Var}(x_i)}\sqrt{\operatorname{Var}(y_i)}} \quad, \quad \rho = \frac{\operatorname{Cov}(R[x_i],R[y_i])}{\sqrt{\operatorname{Var}(R[x_i])}\sqrt{\operatorname{Var}(R[y_i])}} .$$
Ranks follow a uniform distribution by definition. Let's further assume a normal bivariate distribution for nontransformed $x$ and $y$.
Now my question: I want to express $\rho$ as a transformation of $r$. It seems that this should be a fairly simple function that somehow involves a mapping between the normal to a uniform.
My intuition of $\rho$ is that it is a weighted function of $r$ with large weights placed on small distances in the middle of the distribution; again, this would seem proportional to the normal distribution itself.
Is anyone able to work out the specific expression?