What happens to my save file if my Internet drops out? Do I lose all my progress? (Switch)

No. As this is a cloud streaming service, all your progress is stored in the cloud.

Like any game, however, if you lose connectivity or switch off the game between checkpoints, you will be sent to the last checkpoint you saved at when you return to the game.