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 ...
Nintendo Game-key cards are a new innovation with the Nintendo Switch 2 and should not be mistaken for the regular game card. This is exactly the type of thing that is going to catch your granny ...