First, the metric that you write down has Gauss curvature $K\equiv-1$, so if you want to compute distances in this metric, you should write it in more standard coordinates and then use the known distance formulae for the hyperbolic plane. Thus, if you set $(x,y) = (\theta,e^{-r})$, you'll find that $$ \mathrm{d}r^2 + e^{2r}\mathrm{d}\theta^2 = \frac{\mathrm{d}x^2+\mathrm{d}y^2}{y^2} $$ and the right hand side is the Poincaré metric on the upper half plane. Many books have the formula for distance between points in the Poincaré metric. Of course, if you really want $\theta$ to be $2\pi$-periodic (i.e., the points $(r,\theta)=(0,0)$ and $(r,\theta)=(0,2\pi)$ are to be regarded as the same), then you'll have to modify the Poincaré distance formula a little bit to get the true distance.
Second, in the more general case, there is no known way to write down the distance formula for a general warped metric, even in the simplest case: a general surface of revolution. Even in dimension $2$, the set of Riemannian metrics for which an explicit distance formula is known is very small. For one example, see my answer to this questionthis question. There are a few others (some of which have only discrete symmetries), but, as far as I know, there is no general theory on how to classify them.