When you use the front brakes on your bicycle, why does your body want to rotate over the front wheel?

Mechanical Engineering Free Body Diagrams
1

The braking force is offset from the riders COM and that creates rotation.

2

There is also the propagation of rotational kinetic energy from the inertia of the wheel.