make TDI.get_value use get_loc, fix wrong-dtype NaT
the wrong-dtype NaT is a bug, the DTI analogue is fixed in #31163.

The refactor to make get_value is get_loc is basically what we want all of them index subclasses to do (at which point we de-duplicate and possibly get rid of get_value altogether)

cc @jreback 