Basis vectors are defined as $\vec {E_i}=\vec{E_i}(x_1,x_2,x_3)=\frac{\partial\vec{r}}{\partial x^i}$ i=1,2,3. In spherical coordinate system $x^1=r, x^2=\theta, x^3=\phi$
position vector $\vec {R}=r \hat{r}$.
That means $\hat {r}=\frac{\partial\vec{R}}{\partial r}=\hat {r}$
But $\hat {\theta}=\frac{\partial\vec{R}}{\partial \theta}=r\hat {\theta}$
Similarly $\hat {\phi}=\frac{\partial\vec{R}}{\partial \phi}=r\hat {\phi}$
Where am I wrong? Why is r appearing?
You're missing the scale factors
$$ \hat{e}_\alpha = \frac{1}{h^\alpha}\frac{\partial {\bf x}}{\partial u^\alpha} $$
As an example
$$ {\bf x} = \pmatrix{r\sin\theta\cos\phi \\ r\sin\theta\sin\phi \\ r \cos\theta} $$
So
$$ \frac{\partial {\bf x}}{\partial \theta} = \frac{\partial}{\partial \theta}\pmatrix{r\sin\theta\cos\phi \\ r\sin\theta\sin\phi \\ r \cos\theta} = \pmatrix{r\cos\theta\sin\phi \\ r\cos\theta\cos\phi \\ -r\sin\theta} $$
The scale factor is just
$$ h^2 = [r^2\cos^2\theta(\sin^2\phi + \cos^2\phi) + r^2\sin^2\theta]^{1/2} = r $$
So the unit vector is
$$ \hat{e}_2 = \pmatrix{\cos\theta\sin\phi \\ \cos\theta\cos\phi \\ -\sin\theta} $$