Once the export is mounted using either fstab or autofs, Kodi treats it as if it were a folder in local storage. (In fact, Kodi doesn’t even know it isn’t local, only the OS knows). So, a Kodi source should point to somewhere within the home folder structure.
That’s the easiest option, but you could also use Kodi path substitution to map the original file locations to new ones. See: [HowTo] Repairing File Paths with Path Substitution
(I’m not too familiar with that, so I’ll duck out and let someone else explain the details!)