Is sourdough actually sour? Why is sourdough called 'sourdough'? Is it because it is sour to the taste, or for a different reason?
Yes, a well cultured sour dough is actually sour.

The bacteria in the culture, lactobacilli, emit lactic acid as a waste product of their metabolism, making the dough acidic and sour.