Is rowdy a second syllable stressed?

Yes, "rowdy" is a second syllable stressed word. The stress falls on the syllable "dy", making it sound like "ROU-dee".