The longest lasting submersible pumps I have seen ( been in the hobby 35+ years ) absolutely has to be Mag pumps.
I have a couple that are part time pumps and they are 15 years or better.
They are not the quietest pumps, but they are a serious work horse.
I agree with these comments totally, and I would also add that the mag drives foot print is generally as small as I’ve see for the water they move.