Smarty wrote:

Doesn't talk about design differences (if there are any) between,
say, a sump pump and a jet pump.

The tutorial isn't about the various types of pumps. It is more
specific to the question in the original post regarding PSI at
the outlet and how to calculate it.

The original question was - what static pressure can sump pumps
generate.

The material in that PDF file does not give any real-world performance
examples or numbers regarding sump pumps.