Does there exist a real Hilbert space with countably infinite dimension as a vector space over $\mathbb{R}$?

An infinite dimensional (real) Hilbert space has dimension at least $\mathfrak{c}=2^{\aleph_0}=|\mathbb{R}|$ as a vector space. One way to see this is by taking an orthornormal sequence $e_1,e_2,\ldots$, and considering the linearly independent set $\{\sum_{k=1}^\infty t^ke_k:0\lt t\lt 1\}$.

The same fact extends to Banach spaces, but there orthogonality cannot be used to write so short of a proof. A proof is given in this short article by Lacey.

To just see that the dimension cannot be countable, you could use Baire's theorem.

For more on this in the Hilbert space case, see Problem 7 of Halmos's Hilbert space problem book. (It is assumed there that the Hilbert spaces are complex instead of real, but this does not affect your question.)