Could you handle your SO being gone for HALF of the YEAR?!

Okay, so my SO and I are expecting a baby next July. We've been stressed over money and how I'm going to continue working through my pregnancy (I'm an EMT and they don't offer paid maternity leave). Well, yesterday he was given the oportunity to start working for an oil company in which he would make way over what we make combined right now (six figures) but it would require him to be gone for two whole weeks, then home for two whole weeks. I don't know what to think. He says if he takes the job, I could be a stay at home mom and focus on college full time but I can't imagine being home alone without him for half the month, every month. I would love to not have to put my baby in daycare though and be able to care for him/her fulltime & for the two weeks he's home every month, we could spend every second together as a family. Our income would be way higher than it is now and we could get better vehicles (which I desperately need) and a new house eventually (we live in a 1 bedroom apartment right now). What do yall think? Is it worth it? Are there any women out there who already do this and can share their experiences? I was always the kind of woman who couldn't imagine having a husband who was always away with a job in travelling or the military and stuff. So this is uncharted territory for me!