I was terrified before I first went - I'm the world's biggest wuss. Don't like any kind of speed, or being out of control. I agreed to go on a ski trip with friends because of 'FOMO'. I was terrible at it on that trip, but - very surprisingly - better than DH, which gave me the motivation to persevere. I just LOVED being outside all day, in the beautiful mountains in the sun.
DH and I went back the following year, to FInland, where the slopes were gentle and we could build our confidence. Now we go every year, and I just love everything about it. I'm still not very good, but I can get around, and I get so much enjoyment from it.
One of my friends on that first trip was another total beginner. She didn't get on with it at all, and bailed out of group lessons after 2 days, but had private lessons instead. By the end of the week she could ski a blue. We went again as a group 3 yrs later and she had another go, but decided after 2 days that it wasn't for her.
We skiied together as a big group last year, and will do so again next year. We choose resorts where there is plenty for non-skiers (not just swimming and spas). She goes walking and snow-shoeing mainly (the latter isn't that easy, BTW) with groups/guides organised by the tourist office. She is happy, her DH is happy (on 2 fronts - because she is doing something she likes, and because he can ski) and we're all happy too.
Go with an open mind - you may surprise yourself. And I echo what a pp said - it's hard work trudging around in ski boots and carrying skis etc. You'll be knackered before your first lesson even starts. But once the skis are on your feet, and not over your shoulder, and you're going downhill rather than up, things get easier. Good luck!