There are you mistakes in your example:
1. The URL to the hosted font is malformed.
If you access the @import tab of that font family selector on the Google Fonts site you will see that the relavent URL looks like the following;
@import url('https://fonts.googleapis.com/css?family=Open+Sans');
... notice the quotes around the URL value and that it has a https: protocol
2. You are targeting the body element with your font-family related rule.
If you Inspect the CSS being applied to the elements of the main page of your story you will discover that Harlowe assigns it's default to it's custom tw-story element so your CSS rule should like like the following.
tw-story {
font-family: 'Open Sans', sans-serif;
}
If you place both of the above within your project's Story Stylesheet area, making sure that the @import statement comes before the tw-story based rule, then the font change will work.