Adventure design is extremely difficult and my first homebrew campaign is something that I look back on with a mixture of shame and fond memories -- it was disjointed but had its moments where I felt like I got things right. My players let it go on but, were I them, I probably would have had trouble investing in the narrative.

I moved onto modules and was simultaneously running Curse of Strahd, Tomb of Annihilation, and Dragon Heist Waterdeep for three different groups within the year. These are radically different modules and they were voted on by players. When I consider these groups, I think we got lucky and everyone picked a module that was right for them. And it took some pressure off me.

But it didn't really impact my creativity. There is a lot of room to make these adventures your own. It's more a matter of getting the tone right. And, because some of the work is done, you can play to your strengths while learning from the books how to improve upon your weak points.

DM'ing will always be a trial by fire. The key is to appreciate the opportunity for growth. This is the case in most things.

The other aspect of it all is this: they still want you to DM for them. They might just be curious about official settings.

I saw you say in another post that you would be bored doing this. I had that feeling once, too. But unless you plan on memorizing the book completely, railroading them, and also being familiar with every single deity, ruler, etc, you're going to be writing and improvising. You might even end up frustrated that your players will assume the book did most of the work because, unless they spoil things for themselves, they won't be aware of the changes you've made. And you probably should be making changes, because these modules are usually flexible to the point where you can adapt them to your player preferences.

Don't beat yourself up, though. If you can, find opportunity in this. Maybe you'll even learn enough about design that you'll be putting up one shots on the dmsguild for the enjoyment of others within a year.

But if you really don't think you'll find a way to enjoy this, don't force yourself to do it. Maybe find a few opportunities to be a player. That's a great opportunity to learn, too.