This isn’t normal for Steam, though, it’s something the game dev/publisher/owner implemented (even if Steam is somewhat complicit in allowing it at all). Most single player games on Steam still work when you’re offline.