Mystery,
You are correct, you will need a decent flow of water to the engine, but high "pressure" is not needed. The Sea water entering your pump is not "under pressure". Easy to determine, just look at how much water is coming out of the hose. If it is "barely" coming out, then no, don't try it. Also don't use an easily collapsible hose, use a fairly stiff one to better resist your pump's suction. This will maximize the available flow. To ensure you are not damaging your impeller (if you are worried) put your hand on the pump cover while doing the flushing, if it feels hot to the touch, you don't have enough water so either partially open the through hull (still has good FW flushing benefit) or stop the procedure. Unless your impeller is already "damaged or weakened" (in which case it should be changed anyway), the "hand check" will ensure no harm.
To see first hand about FW flushing (without actually doing it), check out Tony Athens website (sbmar.com) and read about first hand accounts in his forums and info under Tony's Tips. Learn about "marine age" and how it slowly (in some cases not so slowly) destroys our cooling systems, and how neglected cooling systems can "badly damage" engines. In case you don't know, Tony is considered by many to be a guru of marine diesel engines and has well over 35 years experience.
While he does sell products on his site (after all this is his profession), he offers lots of free information under Tony's Tips and answers questions directly on the free forums!
I have no affiliation, have not even met the man.... but have benefited from much of this information that he freely supplies, without overly pandering his products.
Freshwater flushing, done regularly, can extend the time needed between full off engine servicing of the raw water cooling components (almost double the interval if done "religiously") because it greatly reduces internal corrosion (mostly caused by the salt water) and slows down the build up of "salt" deposits in the various "tube" (small) passages inside the various HX type of components (aftercooler, gear oil cooler, heat exchanger, etc.)
Freshwater flushing does not remove the need for proper periodic full off engine servicing (including pressure testing to ensure the unit will not leak internally), but it will keep your engine running cooler between servicing, and extend the time between this service, and in effect, save you time and money in the long run.
It's your choice. Spend a few minutes flushing after each trip, or spend time and money servicing or replacing these components more often, also increasing the risk of overheat "problems" when on your trips and away from your regular service providers. I know which path I chose!