Spline paths in Unreal Engine aren’t bezier splines. They are Cubic splines.
Cubic Spline paths always pass through the plotted points. This means that when you sample the rotation using Get Rotation At Spline Point, you are getting an accurate rotation of the point itself, not just the path!