Just been trawling through engineering papers. From what I can see the simple oil pumps in question have limitations. As we know the oil system has two components flow and pressure. The pumps have the capacity to create a flow rate over a wide range in an open pipe and within reason this will increase with speed.
An engine also requires pressure to allow the oil to reach tight places such as bearings and not just find its way out of the easiest holes. They try to control this by changing gallery sizes to account for the local resistance but that is something that can only be averaged eg the big end bearing require more pressure and flow as speed increases because the oil is being "squeezed" out by increasing force but the main bearings can run pretty well on the average allowed by their oil gallery ports.
Although it is not exactly the electricity equivalent the work of the oil is is similar ie Volts(pressure) X Amps (flow) = Watts (the "work") to retain the same work if one goes down the other must go up. In electricity we keep the volts constant and change the Amps to vary our work capacity.
In the oil pump we want the pressure to remain sufficient to oil the bearings at the highest possible speed this is regulated by a spring valve so it is not too high at low speed and not too low at high speed. We can see this plainly by revving the engine and looking at the oil gauge as it falls between a fixed lowest and highest position on the spring valve.
All liquid pumps have a maximum possible flow dictated to by their internal design and the size of the pump and pipes. The one in a vehicle engine has enough for all normal purposes and if left fully open at the outlet would continue to pump more and more according to speed until it reached the limitations of its design, size, piping, fluid viscosity etc.
This is what we see in those graphs. The pump can only do so much work by design so as the engine speed increases the oil is having to push open the regulator valve more and more and the energy required to do that starts to impinge on the design capacity of the pump. In a badly worn engine the oil is pouring through the wider gaps which no longer assist the regulator valve with natural built-in back pressure. Like having a split in a garden hose.
This chart is what happens to all pumps of any fluids. In a vehicle the oil pressure regulator valve can be said to be "head" on say a water pump ( a real water pump not a circulating water pump as in a car engine).
When it reaches its optimum design capacity everything - head (pressure) and flow is all downhill from there.
To answer Paul's question. If we imagine the red power line to be revs which it roughly is for the pump (the pump draws so little power it does not know the total engine output is following a curve and is always supplied with its full needs at increasing rpm) where the graph runs out can be said to be the engine rev limit. Although the flow and pressure are falling badly the engine has been designed that they are sufficient until it throws a rod from mechanical forces not lack of lubrication.