"Lengths" of Random Variables in Infinite Dimensional Spaces

I think @ian answered the question in the comments to OP's post, but here I will rephrase it:

Since the covariance map $ cov(X,Y) to mathbb{E}[(X - mathbb{E}[X])(Y - mathbb{E}[Y])]$ is actually an inner product as shown here, it induces the norm which is precisely the standard deviation map $ sd(X) to (mathbb{E}[(X - mathbb{E}[X])^2])^{frac{1}{2}}$, which in turn induces a metric etc. As someone already explained in another answer, for your geometric intuition: random variables for which $mathbb{E}[X] ne 0$ can be though of as "translated" versions of their $0$-mean counterparts, which is why the $mathbb{E}[X]$ "creeps in" to the formula above.

Let $V$ be a vector space. Examples of $V$ are, $V=mathcal{R}^n$, the n-dimensional space of reals or $V=L^2(mu)={f:int f^2 dmu<infty}$.

A norm $vertvertcdotvertvert$ is non negative real-valued function on $V$ which satisfies the three well known properties.

For $fin L^2(mu)$, a norm is $vertvert fvertvert_2=(int f^2 dmu)^{1/2}$.

In a Euclidean space, for $x=(x_1,ldots,x_n) in mathcal{R}^n$ a norm is defined as $vertvert xvertvert=(sum^{n}_{i=1}x_i^2)^{1/2}$

In a normed space there is an induced metric(a "distance" between its elements) defined by: $vertvert v-wvertvert,;v,win V$.

For $f,gin L^2(mu)$, $vertvert f-gvertvert_2=(int (f-g)^2 dmu)^{1/2}$ and for $x,yin mathcal{R}^n$ the induced metric is $vertvert x-yvertvert=(sum^{n}_{i=1}(x_i-y_i)^2)^{1/2}$ which is the well known Euclidean distance between two vectors.

So, the length of a vector is actually the Euclidean norm on $mathcal{R}^n$.

The variance is a special case. $Xin mathcal{R}$ is random variable ie a measurable function $muin mathcal{R}$ is a constant, the expectation of $X$, and $P$ is a probability measure on $X$ then $$Var(X)=vertvert X-muvertvert_2^2=int(X-mu)^2dP=E(X-mu)^2$$

The standard deviation is the actual norm.

The covariance between two random variables $X,Y$ is the inner product $<X-E(X),Y-E(Y)>;=int (X-E(X))(Y-E(Y))dP$.

Notice that this inner product can produce the $L_2(P)$ norm as special case for $X=Y,;E(X)=0$. $$<X,X>;=int X^2 dP=vertvert Xvertvert_2^2$$ This is the known formula $Cov(X,X)=Var(X)$.

In general norms in $L_2(P)$ spaces cannot be produced from an inner product.

Length is not really the best way to think about norms in function spaces. It is much better to think of the norm as offering a vague notion of size. Thinking of the norm in function spaces as length just connotes too much geometric intuition where there is none. I think you are falling into a common trap when starting out in functional analysis, which is to try to interpret everything geometrically. I'll just say that this is a very problematic way to approach the subject and will cause you more headaches than it will insight.

The reason that the norm is always taken against the zero vector by default is because in vector spaces, the length of vectors is translation invariant. For example, in $L^{2}(mathbb{R})$, we take the norm against the zero function by default $$ lvertlvert f rvertrvert_{L^{2}}=lvertlvert f-0rvertrvert=left(int_{E subseteq mathbb{R}} lvert f-0 rvert^{2}, dmu right)^{1/2} $$ but we could just as easily pick another function, say $g in L^{2}(mathbb{R})$ and write $$ lvertlvert f-g rvertrvert_{L^{2}}=left(int_{E subseteq mathbb{R}} lvert f -g rvert^{2}, dmu right)^{1/2} $$ which tells us how far apart these functions are in some sense (and there are many senses which do not coincide with your geometric intuition). Your standard deviation example just follows from the fact that you have a linear functional $mathbb{E}[cdot]:L^{2}(Omega,mathcal{F},mathbb{P}) to mathbb{R}$ composed with another linear functional $sigma[cdot]:L^{2}(Omega,mathcal{F},mathbb{P}) to mathbb{R}$ given by $$ sigma[X]=(mathbb{E}[(X-mathbb{E}[X])^{2}])^{1/2} $$ and this has nothing to do with how vector spaces work, it is just because of how $sigma[X]$ is defined. It is the "distance" (or how much "size" is between them) from the constant function whose value is given by the functional $mathbb{E}[X]$.

As for your second question, like I said before, our brains are limited to visualizing in 3 dimensions. Trying to "visualize" in an infinite dimensional Hilbert space simply isn't going to work.