This does not sound like something you should do.
She will be sitting home miserable, you will be out flying to different cities and then sitting in hotels...knowing your wife is home miserable and there is nothing you can do about it....week after week after week.
If she was saying "go follow your dream to become a pilot because I love you and want to see you happy and successful" , that would be a different story but she is not saying that and as you said, this is not your dream job.