Could sex the day after ovulation spotting lead to pregnancy?

Yes. It is normal to have a drop in estrogen level with ovulation. This may cause spotting for 1-2 days and will still allow for pregnancy.