Yes, this textbook is a great introduction to point-set topology. I'm not very familiar with algebraic topology so I can't comment on anything regarding that. I did learn a fair bit of category theory that I didn't know prior, like a formal explanation of deriving the Yoneda Lemma (I read this book before I read CWM). I think it's definitely possible to learn category theory from this book, especially if you already have a strong intuition for Topology.