Singularities and dualities of pedal curves in pseudo-hyperbolic and de Sitter space