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 ...
When searching for your next credit card, consider waiting until you can take advantage of an increased welcome bonus. Not every rewards card offers a welcome bonus (or a limited-time increased bonus) ...