This is something you need to agree together OP however it's entirely possible to be a great Dad even if you away a lot.
My DH has always worked long hours, logging in at home in the evenings and at weekends but then so do I, we juggle family life around the needs of our jobs quite happily.
A few years ago he got a promotion which meant hugely increased foreign travel (eg 2-3 weeks in eg Asia, rather than 2 days in Eg France every month). His employer said you need to get your wife on board before you sign up for this and set out quite explicitly how often he was likely to be away etc.
It's been a brilliant career opportunity for him and he really enjoys his job. The seniority has led to increased flexibility too.
So yes, he is away a lot, but when he is home he can work from home, be flexible about his hours and take time off for things like Sports Day much more easily.
He facetimes with the kids every evening he can (depending on the time difference) and usually calls me first thing for a quick chat.
He really makes the most of the time he is home with the kids and is very hands on. He takes them for outings and camping trips and makes time for school projects etc etc.
Now yes, this lifestyle requires me to keep everything going but at home but just because he's away doesn't mean he can't pay bills or organise stuff. When he's not at home the kids and I just slip into a slightly different routine.
It might not work for you OP, but there are pros as well as cons. It's probably worth sitting down with your DH and working out the pros and cons explicitly and seeing if you can manage them/plan around them.