Thanks for the reply, Moses.
The link and explanation you’ve provided appears to apply to the optional CSV Import Suite plugin.
My issue is with the default, in-built CSV product import feature.
There is no documentation I can find that indicates manual field mapping will only work with certain combinations of column heading names.