You should read the introduction to Bhargav Bhatt's lecture notes on prismatic cohomology: available here. This is a new cohomology theory introduced by Bhatt-Scholze (closely related to prior work by Bhatt-Morrow-Scholze) for explaining these torsion phenomena.
The presence of extra torsion in de Rham (or crystalline etc.) cohomology is unavoidable, as SashaP's answer demonstrates. These cohomology theories are only supposed to be reasonable analogues of singular cohomology (i.e. Weil cohomology theories) when you use torsion free coefficients.
However, we can explain where the extra torsion "comes from" (relative to the "true" etale/singular cohomology with e.g. $\mathbf F_p$ coefficients) with a certain long exact sequence.
Let $X$ be a reasonable variety over (e.g.) $\mathbf Z$. Then we can consider its etale cohomology $H^i(X_{{\overline{\mathbf{Q}}}}, \mathbf Z_p)$. This agrees as a module with the singular cohomology of $X_{\mathbf{C}}$, so it's the "right answer" (in particular it's $\mathbf A_1$-invariant).
On the other hand, we can consider the algebraic de Rham cohomology of $X_{\mathbf Z_p}$ (this is essentially the algebraic de Rham cohomology of $X$ tensored with $\mathbf Z_p$), $H^i_{\mathrm{dR}}(X/\mathbf Z_p)$. This agrees with the crystalline cohomology of the special fiber - in particular it only depends on the special fiber, so we shouldn't expect it to capture the same information as the etale/singular cohomology of the generic fiber.
These two $\mathbf Z_p$-modules have the same rank by Fontaine's comparison theorem (at least in the proper case, but if you use some sort of log theory you can extend to the open case), but in general the de Rham cohomology has extra $p$-torsion.
To explain this, Bhatt-Scholze construct a third cohomology theory for schemes over $\mathbf Z_p$ (it's essentially a variant of the construction of crystalline cohomology), valued in modules over the ring $\mathbf Z_p[[u]]$. Let's call this $\mathcal{H}(X)$. Then:
$\mathcal{H}(X)/u$ is isomorphic to de Rham cohomology of $X_{\mathbf{Z}_p}$ (equivalently, it's isomorphic to the crystalline cohomology of $X_{\mathbf{F}_p}$).
$\mathcal{H}(X)[1/u]$ is non-canonically isomorphic to the etale cohomology with $\mathbf Z_p$ coefficients of $X_{{\overline{\mathbf Q}}}$ (equivalently to singular cohomology of $X_{\mathbf C}$), tensored with $\mathbf Z_p((u))$.
$\mathcal{H}(X)$ (at least after some scalar extension) can in principle be computed using a "q-de Rham complex"
(I'm sweeping some homological algebra consideration, about e.g. exactness of modding out by u, under the rug - see the Bhatt-Scholze paper for precise statements. You really need to use derived categories everywhere.)