1. Does it address underlying issues?
It's rare for a person to resign just to receive a higher counter-offer, they usually look for a new job because they feel ready for a change or a new challenge. There are many reasons you may choose to move on, maybe your progress feels stagnant, or you're just ready to take on new challenges. Regardless of the reason, you have to ask yourself how it will be until you start to feel these same things about your current employer and job again. Even if there is a promotion and a pay raise on the table, will you be happy in your current company in 6 months time?
2. Has the bond of trust been broken?
Once your notice has been handed in, it'll be difficult for your working relationship with your manager to go back to what it was before. Even if you accept a counter-offer, the bond of trust you have built will be damaged, and senior leaders may start to question your loyalty to the company. Moving forward, this may hinder professional relationships going forward, and may even impact your day-to-day working life.