There is no need to set relative transform in “add spline mesh component” as it will be handled by “Start and End”. Usually setting “location at distance” to local will do for the position in “Start and End”.
Last check would be to ensure the mesh is facing the correction direction by highlighting the “add spline mesh component” and check the forward axis direction.