If you want a great turn based rpg with a long running story check out the ‘trails’ series.
The series started in the early 2000s and are still releasing games today that are part of the same universe, within roughly the same time frame (about a 10 year spread), and have reoccurring characters. The turn based combat also has a bit of positional/range aspects reminiscent of tactical RPGs but does not cross the line. Older games are sprite based and newer games look like more like anime.
Do note that the starting trilogy, trails in the sky, is currently being remade with a release this year. The story is told in order so do not skip around or jump to a later series.