Let's say $S$ is a $2$-dimensional vector space over the field of the real numbers with a weighted inner product $$\langle x, y \rangle = x^\top Q y ,$$ where $Q$ is a positive-definite matrix. I want to "visualise" this space, so I can make sense of it.
When $Q$ is diagonal, $S$ is simply a version of $\mathbb{R}^2$ stretched along the Cartesian axes. This is easy to understand, so from now on assume $Q$ is not diagonal.
When $Q$ is not diagonal, it gets complicated, because two vectors that are perpendicular in $\mathbb{R}^2$, such as the standard basis vectors $e_1$ and $e_2$, are not perpendicular in the non-diagonal metric $Q$. In short, I have no idea how to make a mental picture of these vectors, or any other vector, in $S$.
One idea I have is to represent a vector $x$ in $\mathbb{R}^2$ along with a transformation $Tx$ which has the length and direction of $x$ in $S$, so I can see the difference between the two. Therefore, to find $T$, I think the first condition should be $$ \begin{split} \lVert Tx \rVert &= \sqrt{x^\top Q x} \\ \lVert Tx \rVert^2 &= x^\top Q x \\ (Tx)^\top Tx &= x^\top Q x \\ x^\top T^\top Tx &= x^\top Q x \implies T^\top T = Q \end{split} $$ But then I don't know how to continue. In particular, I don't know how to find the direction of $Tx$. Where does it point to? To me it seems that the problem is undetermined, and maybe the whole idea is misguided.

-For simplicity, take the induced norm of the weighted inner product which is a quadratic function.
Let $Q_s$ and $Q_{as}$ be the symmetric and skewsymmetric part of Q, respectively. Then,
$x^TQx=x^T(Q_s+Q_{as})x=x^TQ_sx$
due to the fact that $x^TQ_{as}x=x^TQ^T_{as}x=-x^TQ_{as}x\implies x^TQ_{as}x=0$
What remains is the symmetric matrix that can be diagonalzed by the set of its eigen-vectors.
-Regarding your idea to find a transformation that preserves the magnitude and direction, this map is the identity only. And it is not helpful to change anything.
Instead of this you can search about a unitary transformation because it preserves the inner product value $i.e$. if U is unitary, then $<Ux,Uy>=<x,y>$.
In order to find a unitary transformation $U$ such that $U^{-1}QU=D$, Q must be normal matrix, where $D$ is diagonal.
A matrix $Q$ is said to be normal if $Q^TQ=QQ^T$.
A matrix $U$ is said to be unitary if $U^T=U^{-1}$
Regards,