Promotion means more travel and I'm conflicted

Got offered a promotion that's basically my dream job. Better pay, better title, everything I've been working toward. But it requires being on the road 2-3 weeks a month. My kids are 8, 6, and 4. My wife works part time. I keep telling myself the money will be worth it but when I think about missing soccer games and bedtimes I feel sick. Is this the dumb choice? Am I being selfish? Anyone been in this position and can tell me if you regret it either way?