I am sympathetic to your confusion. This stems from the proposition "force causes motion".
I'll try to explain.
Newton stated his 2nd law in words, as the second law of three, as he considered the force as a more or less understood concept, associated with contact of bodies or muscular tension. He also spoke of changes as "compelled", or "caused" by other bodies.
I think this is a matter of choice of the most clear formulation. In his days, when mechanics was still developing, he probably saw his choice of words as better, as it appealed to daily experience and thinking.
However, I think today, it is more useful to define the technical concept of total force more precisely by F=dp/dt, so the proposition called by him "2nd law" becomes rather an advanced operational form of definition of this total force.
Also, I believe that when stating the basic mechanical laws, it is better to refrain from using the notion of causality altogether, as it is usually not necessary to set up the mathematical description of the motion and is quite heavy philosophical notion on its own (much more complicated than mechanics in my opinion).
So today, in effort to state the laws of nature in the most accurate way, we may be putting the "2nd law" differently, but still, the laws of mechanics are not just a bunch of useful definitions, but rather some valuable statements how the things in world usually behave (->force is a often function of t,x,v and -> independence/superposition of forces).
The advantage of the mechanical description with forces is that any motion can be described. In your example, if the coordinate as a function of time is
$$
x(0)=0;
$$
$$
x(t)=e^{-\frac{1}{t^2}},
$$
it is possible to find the force from the definition ##F(t) = m \frac{d^2x}{dt^2}##, and is equal to
$$
F(0) = 0;
$$
$$
F(t) = -2 m \frac{1}{t^4} e^{-\frac{1}{t^2}}.~~~(*)
$$
if I did not made a mistake in the calculation. Of course, this force is just a description, not an explanation of such motion - such force is as strange as the original motion.
but at the next instant the object starts moving, so what causes it to move?
This cannot be found just from the information given. The explanation or cause of such motion can be found only in finding its relation to other bodies, or possibly in answering the question "why is the force given by that expression (*)?". To find that, you have to find physical situation where such motion would occur...