Ok, I have done an excise and the drawing file is attached.
I can't make the model perfectly.
The reason is that there is a difference when talking about "geometrical" theory and "AutoCAD" theory.
In your case, we can imagine that a sweep created from an end profile to an end point can be done and this is "geometrical" theory.
On the other hand, AutoCAD doesn't allow user to set the sweep scale to "0" as the end point is a perfect point and this is "AutoCAD" theory.
On the drawing file, the '01" solid is a copy from yours on its left just in case I might make a mistake. "04" is the profile I created a perfect tangential curve and the sweep path copied from yours. "02" and "03" are the solids using different sweep scales. When you have a close look at the end point on "02" you will see it is not perfectly formed. "03" solid created by "0.001" sweep scale seems ok to me. Back to the "01" solid now, your solid is subtracted by "03" solid and obviously it is not the result you expected. I then created a curve solid "05" which sweep scale is 1. As you noticed "05" solid has a offset from the profile and the sweep path. The sweep path (magenta) on this one is a copy from the top edge of your solid. This explains the result of "01" solid cut. Furthermore, having a close look at the "03" solid, you will also see there is an offset from the sweep path (white) and the solid bottom edge.
All these can tell the reason which we will not be able to create a perfect cut or trim that you descripted.
Hope this explains but not "HTH".
Please mark "Accept as Solution" and "Like" if my reply resolves the issue and it will help when others need helps.
= ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ = ♪ = ♫ =
A circle is the locus of a cursor, starting and ending at the same point on a plane in model space or in layout such that its distance from a given coordinates (X,Y) is always constant.
X² + Y² = C²