For a static spherically symmetric metric below: \begin{equation} ds^2=(r/r_{0})^4~c^2dt^2-dr^2-r^2(d\theta^2+sin^2\theta~d\phi^2),\tag{1} \end{equation} where $r$ is sectional curvature radius and $r_{0}$ some constant, the obtained scalar curvature $S$ yields: \begin{equation} S= 12/r^2.\tag{2} \end{equation} What topology has the manifold characterized by that expression, is it $\mathbb{R}\times\mathbb{S}^3$ or $\mathbb{S}^4$ ?
The idea to understand it as a $\mathbb{S}^4$ originates from the paper on "Riemann manifolds dual to static spacetime" https://arxiv.org/abs/2004.10505. The metric (1) can be written as \begin{equation} ds^2+dr^2+r^2(d\theta^2+sin^2\theta~d\phi^2)=(r/r_{0})^4~c^2dt^2,\tag{3} \end{equation} where $s, r, \theta, \phi$ are coordinates of a four-dimensional Euclidean (Riemann) space.
The simplest topology is clearly $\mathbb{R} \times (\mathbb{R}^3 \setminus \{ 0 \})$. The singularity corresponds to $r=0$, and is a (timelike) naked singularity. The paper you mention has no bearing on this question, it just establishes a correspondence between static spacetimes and Riemannian 4-manifolds which maps geodesics to geodesics.