I looked into carbon offsets of shipping containers from China to the US as part of my job. I was shocked at how little was emitted per container - Probably cost around $40 of offsets for one 45 footer.

Like you said, the bigger issue is the trucks needed for last mile / between distribution centers.