I think most console games will run without any issues even if you pop in the disc to the console without any kind of Internet access.

There's a Twitter account that documents if games work without having access to the console's network/stores: https://twitter.com/DoesItPlay1/status/1474819155173908484