The wind does not have to always be perfectly behind you in order for you to move forward. It's also ok if it's at an angle with the direction you want to go. Just make sure it's not blowing directly from the front of the boat. That's it.

Google tack and gybe. Valheim implements this pretty well and is quite close to what happens in real life.