Local primordial non-Gaussianity from the large-scale clustering of photometric DESI luminous red galaxies