Someone wanted to learn this too, so Grasp built them a personal learning path.
You can keep exploring this one or create a path like this one shaped around you.
Recommended resources
Module 1
Foundations of Game Design
Module 2
Interactive Narrative Design
Module 3
Designing for Young Audiences
Module 4
Audiovisual Design for Interactive Stories
Module 5
Prototyping Interactive Narratives with Twine
Module 6
Introduction to Programming with GDScript
Module 7
Godot Fundamentals: Scenes and UI
Module 8
Scripting the Narrative System in Godot
Module 9
Polishing the Experience: Audio, Effects, and Persistence
Module 10
Physical Game Prototyping
Module 11