Theoretically, it should be "Louie" as in the French king, but I would say 99% of Americans say "Louis" unless they're singing the song. Surrounding cities include St. James, St. Ann, and St. Charles, so people pronounce it like it's spelled. Most locals shorten to "STL".
I hope that helped.