Biden aide resigns over 'abhorrent' comments to reporter