One good thing is you didn't let it go any farther and you didn't act on it. You are right it is going to take some time.The fantasy affair is over, don't beat yourself up too much. You have been married way to long to throw it all away. I would suggest taking your wife away for a romantic weekend to celebrate your promotion and see if you can start that spark again. I bet you can!