Sorry to hear you're running into this issue. The error message—“Unable to merge the photos. Failed to import the final merged result from...”—typically indicates a problem with file access or temporary file creation, especially when working from a network share.
Could you please confirm which version of Lightroom you're using? Also, does the Photo Merge work correctly if the files are saved on a local drive instead of the network share?