According to the reference posted below there is indeed such a map. However, such a map would not exists if one assumes some (minor) smoothness. Note that this is somehow in contrast with the Nash Kupier theorem where the map is indeed $C^1$.
In particular, I will prove below that there is no $C^1$ map $f: U\subset \mathbb R^2 \to \mathbb R^2$ such that
\begin{equation*}
(df)^Tdf=g \, ,
\label{e1}
\end{equation*}
where $g$ is any smooth metric with non zero Gauss curvature.
I believe that the proof below is well known, but I do not have a reference.
First, note that non existence of a smooth map satisfying the above equation follows from the invariance of the Gauss curvature under isometry.
To prove the claim one thus only has to show that any $C^1$ map satisfying the above equation is indeed smooth. For, note that it implies that
\begin{equation*}
(df)^{-1}=g^{-1}(df)^T \qquad \det df=\sqrt{\det g}
\end{equation*}
and thus
\begin{equation*}
\begin{pmatrix}
\partial_2 f^2 &-\partial_1 f^2
\\
-\partial_2 f^1 & \partial_1 f^1
\end{pmatrix}
= \det df \, (df)^{-T}
=\sqrt{\det g} \,df \, g^{-T}.
\end{equation*}
The distributional rowise divergence of the first matrix is zero, hence $f$ is satisfying the elliptic equation
$$
\mathrm{div} (\sqrt{\det g} \,Df \, g^{-T})=0.
$$
Classical elliptic regularity theory implies that $f$ is smooth and thus that the classical rigidity can be applied.
To put the proof in perspective, note that this is a "non constant coefficient" version of the classical argument of Reshetnyak about the rigidity of the inclusion $df \in SO(n)$, as presented, for instance, in these notes.
As a concluding remark, observe that the rigidity comes from the equality between the dimensions of the target and source domain. The Nash-Kupier needs indeed some co-dimension to add winkles to a short embedding in order to make it isometric.