This isn't a direct answer to your question but provides some pointers that relate to the asymptotic distribution of the Pearson correlation in a Gaussian random walk. (Neither replacing Spearman with Pearson nor a Bernoulli random walk with a Gaussian is going to be of much consequence asymptotically; the Spearman may make a small difference, the increments to the random walk should make no difference asymptotically)
There's been a fair amount of work on this kind of problem in the econometrics literature -- unsurprisingly.
Phillips (1986) gives information about the asymptotic behaviour of $R^2$,
$$R^2 \mathbf{\Rightarrow} \frac{\zeta^2\left\{\int_0^1 W(t)^2\, \mathrm{d}t- (\int_0^1 W(t)\, \mathrm{d}t)^2 \right\}}{\int_0^1 V(t)^2\, \mathrm{d}t- (\int_0^1 V(t) \,\mathrm{d}t)^2}\,, $$
where
$\zeta = \frac{\int_0^1 V(t)W(t)\, \mathrm{d}t\,- \int_0^1 V(t)\, \mathrm{d}t\int_0^1 W(t)\, \mathrm{d}t }{\int_0^1 W(t)^2\, \mathrm{d}t\,-\, (\int_0^1 W(t)\, \mathrm{d}t)^2}$
and $V$ and $W$ are independent Wiener processes; at another point Phillips explains $\mathbf{\Rightarrow}$ (which should be able to be carried over, mutatis mutandis):
The notation ‘$\mathbf{\Rightarrow}$’ [...] is used to signify the
weak convergence of the probability measure of $Z_T(t)$ to the probability
measure (here, multivariate Wiener measure) of the random function $Z(t)$.
(p317 and appendix) while Marmol(1996) discusses Bannerjee et al. (1993)
who describe the density of R (rather than $R^2$):
When both variables are I(1), the density of R is close to a
semi-ellipse with excess frequency at both ends of the distribution
and, consequently, values of R well away from zero are far more
likely here than in [the case of two I(0) series].
(I didn't get hold of Bannerjee et al)
I don't agree with their characterization of the shape of the distribution of R; convergence to the limiting case seems to be very rapid, and the shape is almost flat over the middle half of the range:
Those are histograms of the distribution of the correlation of independent $I(1)$ series (cumulated Gaussian) of different lengths -- $n=10,100,1000,10000$, with 100,000 values
generated for each case. We see that the distribution hardly changes between 10 and 100, and seems to be essentially stable after that. It looks to me like a slightly rounded off symmetric trapezium (/trapezoid), flat in the middle half of the range.
Meanwhile the null distribution (under the assumption of independent $I(0)$ series) would be $N(0,\frac{1}{n})$; the standard deviation decreases as $1/\sqrt{n}$; this means more and more of the above distribution is in the critical region as we take longer series.
Here's the corresponding histograms for the Bernoulli random walk and Spearman correlation:
Those are histograms of the distribution of the Spearman correlation of independent cumulated random $\pm 1$ values for series of varying lengths -- $n=10,100,1000,10000$, with 100,000 values
generated for each case.
The equilibrium distribution looks about the same as for the Pearson/Gaussian case, but is perhaps just a little "rounder" (less flat in the middle half).
(Some additional simulations show that this slight difference is indeed mainly due to the Spearman/Pearson difference rather than the binomial/Gaussian)
Nevertheless, even if the distribution is very slightly different, the result will be the same -- both tests will see a very similar increase rejection rate with sample size.
So for random walks we have this stable distribution that settles down pretty quickly with sample size and then stays the same, but the standard deviation of the null distribution of the correlation coefficient shrinks as $1/\sqrt{n}$ so more and more of this distribution will lie in the rejection region as $n$ increases.
Looked at another way -- under the null hypothesis, $\sqrt{n}\,r$ is approximately standard normal, but because the distribution of these correlations don't shrink around zero as sample size increases, $\sqrt{n}\,r$ gets wider with $n$ -- less and less of it will lie within $0 \pm z_{1-\alpha/2}$ as $n$ increases.
Phillips, P.C.B, (1986),
"Understanding Spurious Regressions in Econometrics"
Journal of Econometrics, 33, p311-340.
However the published version has a number of printing issues
so you may also want this working version to be able to get some of the details:
https://cowles.yale.edu/sites/default/files/files/pub/d07/d0757.pdf
Marmol, F., (1996),
Correlation theory of spuriously related higher order integrated processes,
Economics Letters, 50, 169-173
Banerjee, A., Dolado, J.J., Galbraith, J.W. and D.F. Hendry, (1993),
Co-integration, error-correction, and the econometric analysis of non-stationary data
(Oxford University Press, Oxford).