you can use @zeroskilz nodegroups : z-Curve-Sweeper for Blender 3.0+ (Curve-to-Mesh with superpowers)
I’m pretty sure it solves this issue. This is something that is going to be fixed in blender at some point BTW.
To fix it by yourself it’s a little rabbit hole, you need to make the curve non-cyclic , restore the last segment, then curve to mesh, then transfer UV if I recall correctly …