I am not code savvy. Question: Can I just change the theme to Foundation on my existing well-ranking site and expect the same SEO result?
Assuming all other factors are identical as the previous site there should be no to negligible difference.
As with any website change, ensure you use the same page URLs or 301 redirect any that you change
Updating the theme will not have any difference with your SEO. Update away!