I suspect the reason lorries are rating lower is that they're not typically filled to maximum weight capacity, and likely have greater idling losses.
Though a more recent (2017) source gives a better showing for overland transport:
The study shows that barges can move a ton of cargo 647 miles with a single gallon of fuel, an increase from an earlier estimate of 616 miles. In contrast, trains can move the same ton of cargo 477 miles per gallon, and trucks can move the same ton of cargo 145 miles per gallon.
<https://maritime-executive.com/article/barge-transport-wins-...>
The study being "A report commissioned by the U.S. National Waterways Foundation".
"A Modal Comparison of Domestic Freight Transportation Effects On the General Public: 2001–2014"
<https://nationalwaterwaysfoundation.org/file/31/final%20tti%...> (PDF)
Upshot regardless is that water transport is efficient, if not always convenient.