Contrary to what we thought. In the end, the result is different than expected.  The phrase reveals that what was anticipated has altered. (Compare to At the end of the day or Final analysis.)

“After all that trouble to buy a car for the journey, as it turns out, there are no passable roads in that area anyway.”