I wouldn't go so far as to say that it becomes just 'another job' but the initial novelty and excitement does fade fairly quickly. Getting out of bed at midnight to fly overnight in to a CAT C airfield at the end of the second sector loses it's glamour rapidly.
However, the enjoyment of seeing and feeling improvement and progression in all of the different facets of flying an aircraft is very rewarding. It's a cliché but climbing above clouds in to the sunshine on a miserable rainy day still makes me smile, but not as much as a CDA with a landing in the right place at the right speed...in one of our aircraft with no vnav capacity.
It is a very different career from my other business but I enjoy that a lot more now that I get away from it regularly.
You should also not underestimate the impact upon your family. Suddenly, I am not available...with 2 days notice I can be away for two weeks. Can you deal with that...can they?