Is it ok if you wear a pad overnight during spotting?

Yes, it's absolutely find to wear a pad with spotting, you can also use liners, menstrual cups, and softcups. The only menstrual products you can't use with spotting are tampons.