No, turn-by-turn is unlikely to work well. Turn-by-turn is dependent on the underlying mapping to determine what constitutes a junction, and therefore a turn, and unlike roads where there’s a clear classification of “through road” and “side road”, this doesn’t really exist for trails.
That said, off road navigation does work very well. Just keep half an eye on what’s coming up, and it’ll beep loudly as soon as you’re a few metres off course. If you’re starting from a GPX of a ride that you actually did then that’s even better, as you don’t have to deal with the problem of trails not being where the map says they should be.