Hello James:
While connected to WiFi or cellular, Survey123 moblile app will load ESRI base maps (I haven't tried this with any custom tile packages). However, these maps do not appear to load into the cache. For instance, under Settings and the Advanced tab, the size of the Map Cache does not change as maps are loaded and maps do not show when off-line.