$\newcommand\al\alpha\newcommand\de\delta\newcommand\R{\Bbb R}\newcommand\B{\mathrm B}$It follows from the ODE
$$f''=f^{-\al} \tag{1}\label{10} $$
and the condition $f>0$ that $f$ is (strictly) convex. If $f(\infty-)<\infty$, then, by \eqref{10}, $f''(\infty-)>0$ and hence $f(\infty-)=\infty$. So, $f(\infty-)=\infty$. Similarly, $f(-\infty+)=\infty$. So, $\inf f=f(t_0)$ for some real $t_0$. By shifting, without loss of generality $t_0=0$.
Now take any real $\de>0$ and let
$$g(z):=\int_\de^z\frac{dy}{\sqrt{k(\de^{1-\al}-y^{1-\al})}}
\Big[=\frac{\de ^{(\al +1)/2} }
{\sqrt{2} \sqrt{\al -1}}\,
\B\Big(1-\Big(\frac z\de\Big)^{1-\al};\frac{1}{2},\frac{1}{1-\al }\Big)\Big]$$
for real $z\ge\de$, where $k:=\frac2{\al-1}$ and $\B$ is the incomplete beta function. Then $g\colon[\de,\infty)\to\R$ is a continuous function strictly increasing from $0$ to $\infty$ on the interval $[\de,\infty)$, and $g$ is smooth on the interval $(\de,\infty)$, whereas $g'(\de+)=\infty$.
For real $t$, let $f(t):=g^{-1}(|t|)$. Then $f$ is a solution to ODE \eqref{10} with $\inf f=f(0)=\de$ (see the Detail below). So, $f$ is the only solution of \eqref{10} satisfying the initial conditions $f(0)=\de$ and $f'(0)=0$.
Moreover,
$|f'|=\sqrt{k(\de^{1-\al}-f^{1-\al})}\le\sqrt{k\de^{1-\al}}$, so that $f$ is Lipschitz and hence locally Hölder. However, this solution $f$ of ODE \eqref{10}, which is unique up to the shifting (given $\inf f$ ), is not globally Hölder with any exponent $<1$, because $f'(\infty-)=\sqrt{k\de^{1-\al}}>0$. So, there is no solution $f>0$ of \eqref{10} that globally Hölder with any exponent $<1$.
Detail: On the interval $[0,\infty)$, we have $f'=\sqrt{k(\de^{1-\al}-f^{1-\al})}$ and hence
$$f''=\frac{-k(1-\al)f^{-\al}f'}{2\sqrt{k(\de^{1-\al}-f^{1-\al})}}
=f^{-\al},$$
so that \eqref{10} holds on the interval $[0,\infty)$. Similarly, \eqref{10} holds on the interval $(-\infty,0]$.
For an illustration, with $\al=3/2$ and $\de=3/10$, here are the graphs $\{(z,g(z))\colon\de\le z\le5\}$ (left) and $\{(t,f(t))\colon|t|\le g(5)\}$ (right):