Note firstly that MSE, unlike the related measurement; variance (Var), is a biased estimator of a sample variability, which is one source of confusion in the text quoted. For a normal distribution (only) the relationship is $MSE(\bar{X})=\frac{n-1}{n}Var(\bar{X})$, with a more general relationship given through excess kurtosis correction. This confusion arises because as a sample MSE becomes a population MSE and a population Var, as $\lim_{n\to\infty}\frac{n-1}{n}=1$, that is, MSE is unbiased for a (very large) population, but is biased for $n$ small. The Wikipedia entry is admixing $\mu$ with $\bar{X}$ and $s^2$ with $\sigma^2$, and this is confusing, but is clearly referring to the population (very large $n$) case only. The entry attempts to gloss over this difficulty using the sentence "Suppose the sample units were chosen with replacement.", which is a curt description of bootstrap somewhat unconvincingly implying that we can make $n$ appear to be very large, using $n$ small. Also, note that there are limitations that apply to MSE usage.
More confusion arises not from MSE itself, but from a consideration of what to best use as the estimator of location for the individual distributions that MSE is applied to, as follows. For a normal distribution the mean value is a minimum variance unbiased estimator MVUE for location. However, for a uniform distribution (UD) the mean value is not MVUE for location. The UD mean value is unbiased, no problem there.
However, for a uniform distribution the midrange value, i.e., $\dfrac{\mathrm{max}-\mathrm{min}}{2}$, is also unbiased and is a better estimator of location than the mean value because the variance for the midrange value is less than the variance of the mean. To put it another way, for $n$ increasing, the UD midrange value converges faster to the central value than the mean value does.
Finally, Harter (1942) cites that Fisher (1922) "...has shown (p. 321) that the distribution of the mean of a sample of any size from a Cauchy distribution that same as that of a single observation and (pp. 348-351) that for a sample from a rectangular distribution the extreme observations contain the whole of the relevant information in the
sample; as the sample size $n$ increases, the mean square error of the midrange decreases like $n^{-1}$ and that of the mean only like $n^{-\frac{1}{2}}$."
So, in other words, for a uniform distribution, MSE of midrange, $MSE\left(\dfrac{\mathrm{max}-\mathrm{min}}{2}\right)$ is preferred to MSE of the mean, $MSE(\bar{X})$ .