There exist two methods of integration by substitution.
The first is:
While the second is:
Unfortunately, I'm having some trouble in understanding clearly the difference between the two; they appear to me as the same thing. Can someone explain to me (possibly by words, I'm not asking mathematical rigorous demonstrations) where is intuitively the actual difference?


One way of looking at these is that Theorem 1.18 discusses "straightforward substitution", while an example of Theorem 1.27 is trigonometric substitution.
For Theorem 1.18, consider for example $f(u) = \frac{1}{2}\cos u$, which has antiderivative $F(u) = \frac{1}{2}\sin u$. Let $\varphi(x)=x^2$. Then to integrate $x\cos x^2$, we get $$\int x\cos x^2\,dx = \int f(\varphi(x))\varphi'(x)\,dx = F(\varphi(x)) = \frac{1}{2}\sin x^2,$$ which is correct.
For Theorem 1.27, consider instead trigonometric substitution. For example, let $f(x) = \frac{1}{\sqrt{1-x^2}}$, and let $\varphi(t) = \sin t$. Then $$\int f(x)\,dx = \int f(\varphi(t))\varphi'(t)\,dt = \int\frac{\cos t}{\cos t}\,dt = t+C\,dt.$$ Substituting $\varphi^{-1}(t) = \arcsin x$ for $t$ gives $$\int \frac{1}{\sqrt{1-x^2}}\,dx = \arcsin x + C,$$ which is correct.