Checking a run on my pump. A 10 gpm.. started at 1150 watts and slowly reduced to 1125 . So as the pressure increased the load decreased. Maybe not exactly the same thing but I believe it does show a type of example.
As you noticed there will be a little drop in amps as the pressure increases from 40 to 60 PSI. But that is in what is call the flat spot of the curve where there is very little difference in flow. At 40 PSI and 1150 watts it maybe doing 12 GPM. At 60 PSI it is still doing 10 GPM and only drops to 1125 watts, but there is still a drop in amperage as back pressure increases. With a ball valve or a CSV on the well head that could restrict the flow to 1 GPM, the back pressure before the CSV will be like 100 PSI, but the amps should drop to as low as maybe 800 watts. So yes, that is a good example.
However, some pumps drop in amps more than others, depending on the impeller design. Plus, there is not much drop in flow on a 10 GPM pump to 1 GPM like there would be on a 20-25 GPM pump down to 1 GPM. You should also realize that that drop in amps, similar to a VFD, is not linear with the drop in the flow rate. So, even though the amps drop by 50% or so, it is costing more per gallon to pump a gallon of water. To be efficient with a CSV or a VFD, the flow rate being used must still be close to BEP or the pumps best efficiency point (WHICH IS AT RATED SPEED AND MAX FLOW).
However, the amps do not have to drop very much, only like 10% to de-rate the motor load enough that it could safely pump hot water if needed. Therefore, it takes very little flow, like only 1 GPM to keep the motor cool. It may not be most efficient to use a 10 or 25 GPM pump at 1 GPM, but it certainly will not hurt anything. It is actually keeping the pump from cycling on and off, which is making the pump last longer.
A VFD "creates" a smaller motor from a larger one, it does not "de-rate" the motor load like a CSV does. That means the VFD controlled motor still needs as much cooling flow as a fully loaded smaller horsepower motor, which is still the 0.5 fps and much more than the 1 GPM you can do with a CSV. For efficiency, it is still required to run sprinkler zones and high use loads at close to max flow of the pump, regardless of VFD or CSV.