I don't know how to find the biggest product when $x_i$ are not the same.
But the maximum product is when they are the same, so you're actually asking a different question (kind of) when you fix one of the $x_i$ values.
What happens when you do ?
Let's arbitrarily pick $x_N$ to fix, in which case we want to maximize :
$$x_1^2x_2^2...x_{N-1}^2$$
We can ignore the $x_N^2$ as it's fixed and positive anyway.
Looks pretty similar to what we started with.
So what about the constraint ? That becomes :
$$\sum ^{N-1} _i x_i^2 = 1 - x_N^2$$
And as we can easily see that if we just define a new variable $y_i$
$$y_i := \frac {x_i} {\sqrt {1-x_N^2}}$$
We can now get our original problem form back in an $N-1$ dimensional form :
$$maximize\, \prod ^{N-1} _i y_i^2$$
$$subject\, to\, \sum ^ {N-1} _i y_i^2 = 1$$
Which is is the same as our original form and requires :
$$y_i = \frac 1 {\sqrt N}$$
and so :
$$x_N^2\prod ^{N-1} _i x_i^2 = \frac {x_N^2 (1-x_N^2)^{N-1}} {(N-1)^{N-1}}$$