Asgore deeply cares for his loved ones, but will do what is needed for the sake of the Greater Good. An example of this is when Asgore purposefully created Death to create balance. He made the decision knowing that it will upset Toriel, but with humility and sadness.