I guess its possible, there is software around for transferring files via LoRa, normally from SD card to SD card. You might be able to adapt the software for OTA, that would depend on your programming ability.
if you can transfer the application binary over Lora, then you can apply it the same way the WiFi OTA does or with InternalStorage from my ArduinoOTA library.
LoRa was designed to be flexible but especially suitable for long range operation in unlicensed frequency bands. For this it's great for sending short messages infrequently over long range. It does that by sending them in effect at a low bitrate in a narrow band using a clever spread spectrum technique. The regulations also prevent sending very frequent messages in bands like 865 MHz which have to be shared with other systems, through a duty cycle limit. In bands like 2.4GHz you can flex the system differently to get higher bit rates. But then you won't get the long range with low power, because (a) it isn't narrow band and (b) 2400MHz has a built-in 9x link disadvantage compared to ~800MHz (unless you use directional antennas). Long range/high bandwidth/low power/low duty cycle are incompatible. So it all depends on what the actual requirements are. Cellular systems like 4g are designed for high bandwidth and good coverage.
You pay your money and you take your choice. The OP doesn't say how far apart the picos are - i.e. what range his LoRa link is.
Indeed, the OP does not state the 'distances' involved.
But then if you don't know the environment, whether it is pure line of sight versus say an urban environment, then 'distances' on their own are mostly not meaningful.
The range is not specified yet. Its not mobile but can vary from device to device. So it will be some kind of Master/Slave Point to multipoint system. Maybe 500m to 3km.
One option would be using wifi on every Slave and go there with the phone and update.