This is my understanding of a Cartesian tensor: Any vector in three-dimensional space can be written in a Cartesian system as $$\vec{A}=A^1\hat{e}_1+A^2\hat{e}_2+A^3\hat{e}_3$$ where $A^1, A^2, A^3$ are the components of $\vec{A}$ in a Cartesian basis $\hat{e}_1, \hat{e}_2, \hat{e}_3$. Under a rotation of the coordinate system, the components transform according to $$A^{\prime i}=\frac{\partial x^{\prime i}}{\partial x^j}A^j=R^i_{~ j} A^j$$ where $R$ is the orthogonal rotation matrix. This is a Cartesian vector.
What is not a Cartesian vector (or tensor, in general)?
References:
https://en.wikipedia.org/wiki/Cartesian_tensor
https://mathworld.wolfram.com/CartesianTensor.html
I will expand the question after some time and will also give textbook references. I am also thoroughly confused by the terminology but it does exist.