Your movie has a similar basic plot to The Hidden. I know from your description that you are not referring to The Hidden, which is about a fugitive criminal alien entity taking over the bobies of innocent humans, one by one, and committing awful crimes, baffling the local police detective played by Michael Nouri. Kyle Mclachlan plays the good alien cop occupying the body of a recently deceived FBI agent, hunting down the alien fugitive that had killed his partner back on his home world. But, your movie is quite similar. It even has a touching ending, like the one you describe, but with the good entity living inside a husband, not wife.
It was a great movie. If you haven't seen it. I recommend it.
It was a great movie. If you haven't seen it. I recommend it.