Define $F(X) = {\rm{Hom}}_{\mathbf{C}}(X,{\rm{Spec}}(R/tR))$ where $R$ is the valuation ring of an algebraic closure of $\mathbf{C}((t))$. Note that every element of the maximal ideal of $R/tR$ is nilpotent yet also an $N$th power for arbitrarily large $N$. For any noetherian $\mathbf{C}$-algebra $A$, every $\mathbf{C}$-algebra map $R/tR \rightarrow A$ carries the maximal ideal into the nilradical of $A$. But the nilradical of $A$ has all elements with vanishing $n$th power for some uniform $n$ (depending on $A$) since $A$ is noetherian, so in fact the maximal ideal of $R/tR$ is killed by any such map. In other words, the restriction of $F$ to the full subcategory of locally noetherian objects is represented by ${\rm{Spec}}(\mathbf{C})$.

This is a perfectly "real world" example, since valuation rings of algebraic closures of complete discretely-valued fields come up all the time in number theory and rigid-analytic geometry.