This is the "for worse" part. How you choose to move forward dictates whether you hold up your end of the deal. If the best thing you can do for your S is to let them go be happy, then that's how you can support them.
If you can truly let them go and let them go be happy that is true love. Anything else is manipulation based on fear, lack of stability and loss of control.
The majority of the people here fall into the second category but that does make for a good Hollywood movie.