Got offered a promotion but it means more travel

So I got the call I've been working toward for like 3 years. More money, title change, the whole thing. But it's got at least 2-3 weeks travel a month. My kids are 5 and 8, and I already miss enough stuff due to work. Talked to my wife and she's supportive either way but honestly I'm torn. Is a promotion worth missing bedtimes and soccer games? Or am I being too romantic about it and just need to hustle for my family's future.