Is tale a common noun

Yes, the Word tale is a common noun, a Word for any tale of any kind.

A proper noun is the name of a specific person, place, thing, or a title; for example:

• Old Tale Road, Boulder, CO
• Tale of the Whale (restaurant), Nags Head, NC
• Tale Of Spice (restaurant), Chippenham, United Kingdom
• "The Professor: A Tale" by Charlotte Bronte
• "The Tale of Despereaux", 2008 animated feature with Matthew Broderick