The current density is defined by the history of $E(t)$. For simplicity we will concentrate on the case of a "perfect metal" and not a superconductor (where the underlying physics is more intricate but also real).
Zero (DC) resistance does not mean infinite acceleration. Technically, (DC) conductivity is defined as the linear response in a steady state that is achieved when the perturbation is turned on adiabatically from $t=-\infty$.
So zero resistance (or infinite conductivity), tells us the current will be infinite after the non-zero electric field has been applied for eternity!
If we consider the real problem, we have to consider the actual time dependence: The electric field has been turned on at some time $t_0$, or more generally the field is $E(t)$. Now, the charge carriers have an effective mass and are accelerated according to $eE = F = m_\text{eff} a$, so due to this effect the current is increasing linearly with time (since $I(t) = env(t)$ and $v(t) = -eEt/m_\text{eff}$). There are additional complications due Bloch oscillations in crystals and due to the non-conservation of the quasi-particle number in superconductors, which we put aside for now.
An additional effect preventing instantaneous infinite current is the inductance of the wire, which will limit the current increase with time (since the change in current induces an electric field opposing the accelerating field).
Note that this discussion is not hypothetical: superconductors come very close to allowing dissipation free currents and there the actual current density depends on the history of the applied field (superconducting MRI or accelerator magnets to not need to be connected to a voltage source constantly, they can be short-circuited and the current keeps flowing). Also note, that a perfect metal (with free electrons, not impurities and no phonons) does indeed have non-zero AC conductivity due to the inertia of the electrons. The characteristic quantity describing the scaling of the AC conductivity is the plasma frequency (above which the metal becomes non-conductive).