Yes it should work in offline mode as well. Challenge tracks will not work, because they are downloaded from server, but besides that everything will work offline.
PS: If you are talking only about the prompt at the beginning asking you to enable network features then feel free to say no to that. That prompt only enables LAN (Local network) play aka if you want to play multiplayer with someone in same house.