Let $\mathsf{Man}$ be the category of smooth manifolds. Denote by $|~|$ the forgetful functor to $\mathsf{Top}$. If $X \to S$ and $Y \to S$ are morphisms in $\mathsf{Man}$, then $X \times_S Y$ exists and $|X \times_S Y| = |X| \times_{|S|} |Y|$ under suitable assumptions, for example when $X \to S$ and $Y \to S$ are submersions, right? But my actual question is:
Question. What is an explicit example for morphisms $X \to S$ and $Y \to S$ such that $X \times_S Y$ does not exist in $\mathsf{Man}$?
Of course it is not enough (a priori) to prove that $|X| \times_{|S|} |Y|$ is not a manifold. On the other hand, it is easy to see, using morphisms from the point, that the underlying set of $X \times_S Y$ is the fiber product of the underlying sets.
I am also interested in related categories, for example topological manifolds, Banach or Frechet manifolds. Also I would like to add a soft question: The theory of manifolds doesn't really suffer from the failure of the existence of fiber products, right? On the other hand fiber products play an essential role in the theory schemes, which can be seen as "algebraic manifolds". What is a possible reason or explanation for this asymmetry?