What are the differences between manual butterfly valves and turbine butterfly valves?

That is the difference in driving the valve. One is manual operation and the other is worm gear drive! However, manual operation includes turbine drive; worm gear and handle can be called manual operation.
Worm gear butterfly valves are driven by worm gears, but they also need to be operated manually by turning the hand wheel, so worm gear butterfly valves are also a kind of manual butterfly valves.CPVC Worm Gear Butterfly Valve
Manual butterfly valves are divided into handle butterfly valves and worm gear butterfly valves.
The handle butterfly valve is the butterfly valve that uses the handle to operate the valve switch.
Turbine butterfly valve is equipped with a turbine device on the butterfly valve, which is turned to the hand wheel to operate the valve switch.
Turbine butterfly valve is more labor-saving in operation than handle butterfly valve.
For low-pressure pipelines with a diameter of less than 200mm, both handle butterfly valves and turbine butterfly valves can be used universally. For low-pressure pipelines larger than 200mm, turbine butterfly valves are more suitable. Because the diameter becomes larger and the torque increases, it will be difficult to open with the handle. In high-pressure pipelines, where the torque is large, turbine butterfly valves are recommended.