I tried using the substitution of $u=\cos\theta-2$ which gives $\dfrac{d\theta}{du}=\dfrac{-1}{\sin\theta}$. Then,
$\displaystyle\int\dfrac{\sin^3\theta}{\sqrt{\cos\theta-2}}\,d\theta=\displaystyle\int\dfrac{\sin^2\theta\sin\theta}{\sqrt{u}}\left(\dfrac{-1}{\sin\theta}\right)du=-\displaystyle\int\dfrac{\sin^2\theta}{\sqrt{u}}du$.
I am stuck here...perhaps using $\sin^2\theta=1-\cos^2\theta$ might help, but I don't know how.
As Beni points out, this only makes sense in the complex setting (and with a choice of branch cut), but you can put the integral in terms of $u$ alone via the Pythagorean Identity: $$\sin^2 \theta = 1 - \cos^2 \theta = 1 - (u + 2)^2 = -(u^2 + 4u + 3).$$