For these conditions you have chosen the absolutely wrong type of radio channelFor the Lora radio channel you can seeSemtech LoRa Calculator https://www.semtech.com/design-support/lora-calculatorand estimate what maximum data rate you can achieve
Try using the "AT_Slave" project example from ST I-CUBE-LRWAN library for B-L072Z-LRWAN1 dev board.In I-CUBE-LRWAN it is in the folder "\Projects\B-L072Z-LRWAN1\Applications\LoRa\AT_Slave".From readme.txt:"This directory contains a set of source file...
From https://www.murata.com/-/media/webrenewal/support/faqs/products/lpwa/lora/hardware/lora_lineup.ashxCMWX1ZZ ABZ-078 - "test firmware" ( not "LoRa Modem Firmware" !)I worked with such modules using modified libraries from STM
