Plain-English answer
The pump type follows the job.
A sump pump, pool pump, well pump, fire pump, booster pump, irrigation pump, and solar pump may all move water, but they solve different problems. Some live underwater. Some boost pressure. Some circulate. Some protect buildings. Some must meet code. Some must tolerate debris.
Pick the job first. Then pick the pump.