if the tang on the bottom of the cam sensor sheared off it would fail to drive the pump.
Other than when it happened to me, I've never heard of it happening. In my case, it was a result of running it so hot the driven oil pump gear welded itself in place and locked the pump up.