You are expecting the bicycle to turn over from the point of view of the bicycle itself (fixed pivot point). That is, you are adopting the (accelerating) rotating reference frame. In that case, you need to include the virtual centrifugal force, acting to the left, which counteracts the weight.