Yes it can be both positive and negative. Negative is as in your example "full of foolish pride"

For some people, pride is considered a capital sin So yes, pride can have a negative conotation