First make it position:fixed and position it where you want it on the page. I can’t find the video in your project so do that first.
Essentially then you can replicate this but opposite. Show & Hide Navbar on Scroll - Webflow interactions and animations tutorial - YouTube
Or at least it will get you close. How familiar are you with interactions?