The functor you define is a composite of two functors: the scheme-representable functor $\textbf{Sch}(-, X) : \textbf{Sch}^\textrm{op} \to \textbf{Set}$ and the functor $\textrm{Spec} : \textbf{CRing} \to \textbf{Sch}^\textrm{op}$. Now, it is a general fact about representable functors that they map all colimits to the corresponding limits, so for example $\textbf{Sch}(-, X)$ will map disjoint unions of schemes to products of sets, etc.
The problem is in the $\textrm{Spec}$ functor. Unfortunately it is not true that $\textrm{Spec}$ sends limits in $\textbf{CRing}$ to colimits in $\textbf{Sch}$: in fact this is not even true for products. For example, if $k$ is a field and $A$ is the product of infinitely many copies of $k$, then $\operatorname{Spec} A$ is not going to be the disjoint union of infinitely many copies of $\operatorname{Spec} k$. (Assuming the axiom of choice anyway...) However, it is well-known that $\operatorname{Spec} 0 = \emptyset$ and $\operatorname{Spec} A \times B = \operatorname{Spec} A \amalg \operatorname{Spec} B$, so $\textrm{Spec}$ at least sends finite products to finite coproducts.
Also, essentially by design $\operatorname{Spec}$ fails to preserve equalisers. Indeed, if $\operatorname{Spec}$ preserved equalisers then there would be no chance of constructing any projective schemes. (Consider the construction of the projective line by gluing together two copies of the affine line.)
In summary, the functor of points does not preserve all limits in general; but it does at least preserve finite products.