Yes and no. To be creative, one needs to take definitive steps and your actions aren't definitive or creative if you aren't knowing what you're doing. I'm not talking about positivist, rationalist knowledge, but owning your experiences and actions. You mentioned the need to pivot, and to do so you need something tangible on which to pivot.

I suggest that if you want to be creative, you can't be dogmatic. I've learned that knowledge and creativity need to be dynamic, continually open and continually adapting to circumstances. That's how you find meaning in unrelated things. To be dogmatic is the opposite of dynamic and flexible. Paradoxically, being dogmatic is not being certain, it is the way of hiding one's uncertainty by refusing to be open to the possibility of being wrong.

For me, not doubting myself, being certain in myself and my abilities, but being open and always questioning myself and my directions are the keys to creativity.