The rotation group in $N$ spatial dimensions is $\mathrm{SO}(N)$ by definition.
[...] rotations in real 3D Euclidean can also be described in terms of 2x2 unitary, matrices with determinant +1.
We should be precise here. What we want are projective representations of $\mathrm{SO}(3)$. We can obtain these by exponentiating a representation of the Lie algebra $\mathfrak{so}(3)$.
However, projective representations are annoying to work with. Because $\mathfrak{so}(3)\simeq \mathfrak{su}(2)$, any representation of $\mathfrak{so}(3)$ can be translated into a representation of $\mathfrak{su}(2)$, and exponentiating the latter yields a genuine (not projective) representation of $\mathrm{SU}(2)$.
In this sense, there is a direct correspondence between projective representations of $\mathrm{SO}(3)$ (which are what we want) and genuine representations of $\mathrm{SU}(2)$. Since they are equivalent and the latter are much nicer to work with, we use them instead - but that doesn't mean that $\mathrm{SU}(2)$ is the rotation group.
I am confused because rotations in real 3D Euclidean space can also be described in terms of 2×2 unitary matrices with determinant +1.
If we associate
$$\mathbf x \equiv \pmatrix{x_1\\x_2\\x_3} \leftrightarrow \pmatrix{x_3 & x_1-ix_2 \\ x_1+ix_2& -x_3} \equiv \tilde{\mathbf x}$$
Then for each $U\in \mathrm{SU}(2)$,
$$U \tilde{\mathbf x} U^\dagger \leftrightarrow R \mathbf x$$
for some $R\in \mathrm{SO}(3)$. However, note that $U$ and $-U$ correspond to precisely the same $R$. In other words, the association of elements of $\mathrm{SU}(2)$ to elements of $\mathrm{SO}(3)$ is two-to-one (each element of the latter corresponds to two elements of the former which differ by a minus sign). This is what we mean when we say that $\mathrm{SU}(2)$ is a double-cover of $\mathrm{SO}(3)$.