California’s public worker pension system picked Houston-based Hines to take over a beleaguered real-estate project in its hometown of Sacramento.

The move is a dramatic pivot for the $381 billion pension fund known as Calpers. Sacramento officials cheered its decision last year to move forward with a plan by real-estate developer CIM Group for an office-condominium-retail complex that would have been Sacramento’s tallest tower.

But...