"It kinda disincentivizes me from sharing progress when there are slop ghouls around every corner." ...

After that initial download, you won't need a connection to play, but the card does need to be inserted into the Switch 2. Game-key cards are also not tied to a Nintendo account, so you can use them ...