I'm also curious about LoRA / sneakernet applications. Have those been widely used in cases of censorship?

Lora is fine if you want to send a very short message. Its not useful for much else.

Its also not a prevalent technology compared to general.internet/mobile phone.

Organising resistance with it is the pipe dream of those who play with chips and antennas, but its not something thats going to happen when crowds and mobs form up in a situation like this. Not least because the hardware is not accessible to your average citizen.