An archbishop whose marriage scandalised the Vatican is giving up his wife and returning to the Roman Catholic Church.