How to twist the curve
You need to add more control points in order to achieve what you are looking for, using proportional editing. Try selecting all and subdivide the curve a couple of times, or just the portion you want to twist. Then select the last control points (as you have already done in the gif) activate proportional editing and rotate.
Hope it helps.
Cheers