like Konstantin states, the video is unavailable - maybe you set it to private?
In general, one “standard” way of having geometry “look ahead” on a curve is to have a second locator/null/handle move along the same curve as the geometry, but slightly ahead (if you are using a percentage value for the current position of your geometry based on the timeline, you can grab that value and just add some arbitrary small value on top).
That way you have a goal for a “look at” constraint for your geometry.
One problem with this approach is, of course, that narrow turns can create problems, if the look-at-target is coming back at the geometry, passing it by too fast. But that's a) a layout question for the curve, b) a question for fine-tuning the offset between the two components on the curve and c) shot-dependent
I hope this helps. Let me know if I should make a video …