Husband traveling for work

So my husband just brought up that he wants to look into this job he heard abt that travels all week and is home on the weekends. Apparently it pays good money. He makes good money what he’s doing now and is home around 2-3pm everyday but does go in at about 5am. He drives a truck and has always said he loves driving. But now he is saying he hates his job and wants to look into this traveling job. We just had our first baby 3 weeks ago. I’m a stay at home mom and honestly cannot imagine him being away all week and only seeing him on the weekends. I think it wouldn’t be good for our marriage because I would be miserable. But he keeps telling me I need to think about what will make him happy. And I take that as- he is saying he’ll be happier being away all week. I don’t know if I’m being selfish but all I want to do is cry.. anyone have advice?