Anti-brane singularities as red herrings