Marry for yourself, not for someone else.
Surely we have grown beyond marrying to please our parents or our friends. Yet in first marriages, people often marry to please their parents or friends. They marry the person they love the most who also pleases their family and friends.
In second marriages, people are often concerned with pleasing their children (even their grown children) instead of their family and friends.
But you are the one living with the new partner, not your children. Even young children will leave home and start their own lives eventually. And grown children usually get over it!
This doesn’t mean you should not listen to your children. They may see things that you, that person in lust at the time, are missing.
Hear them out. Thoroughly investigate their concerns.
Then follow your own heart.