It's a term few decades old, and means transferring files between local devices.
You download the app on your pc, you sideload it to your local device (your phone) using adb sideload file.apk, and you use that installed app to upload pictures of your mom.
Everyone now having internet access in those local devices means you can do the download on it directly, but for android, the process is still there and used whenever you install stuff not from the play store.