It's a terrible idea either way. People usually vote for local judges knowing only the candidate's occupation (since it's indicated below their name). Doing research on candidates is hard work, especially local ones you can't find on YouTube, and few will consider leaving a choice blank if they don't know who to pick.
Supreme Court justices are appointed to lifetime positions specifically to give them the freedom to ignore politics and use their literal best judgment (if they can make it through congressional approval). What kind of supreme judge gets subjected to judgment every few years?