Does the word mayor have a long sound?

No, the "a" in "mayor" has a short sound, similar to the "a" in "cat".

The long "a" sound is typically represented by the letter "a" followed by a silent "e", as in "cake", or by the letter "a" followed by a consonant and then "e", as in "name".