We are thrilled about Patrick's promotion, aren't we?

Patrick started his profesional life in 1995 just after finishing university (God, we are old). He has worked as a software engineer all his life. Like most of our friends, he is very dedicated and works hard. He has had ups and downs along the way, but I truly believe that things happen for a reason. Take Logitech, for example. I thought Patrick would stay there for a long time, but things worked out differently. (I dislike them terribly, but please keep buying Logitech mice and keybords, etc. We still owe some of their stock and some of our dearest friends are still working there).
Anyway, Patrick is now in a small company turned huge company (they were bought last Summer) and he was getting a little anxious about his prospects with them. he started looking around and testing the waters for a better oportunity... and he got it!
He was just promoted to a position that still has no title and we have no clue of the salary increase (if any), but we are very excited still.
Patrick is now very aware of the meaning of "be careful what you wish for". He always wanted to have more responsibility. He always wanted to be a manager and be able to mentor young engineers. He always wanted to be more involved in the development of new products. Well, he is getting his dream and feels completely SCARED!
I think is cute and funny. As my father said, he would think less of Patrick if he did not feel a little scared about the new challenge ahead. I told him that he feels like the pre-schooler that is scared about starting Kindergarten. He doesn't want to leave his old friends, and he is not sure if he is going to like his new teacher.
All I want to do is kiss his rapidly expanding forehead and say "my darling Patrick, everything is going to be just fine and you will be great. I promise".
How do I feel about Patrick's promotion? I thought you would never ask...
Part of me is very happy and proud. the idea of more money is promising....but... I cannot help but feel somewhat worried about the balance in his life. I already promised him that I will be very supportive and understanding until he gets the ball rolling. I am sure there will be long nights, trips, weekends working, etc. That is all o.k. for the first six months and here and there after that. I just pray to God that his new job won't consume him in a way that he will have no time left for his two wonderful children and his amazing, sexy wife.