How beginner friendly is it?

I always wanted to play D&D and/or a crpg and now I see the hype about BG3, but when I watch streams and let's plays I don't understand most of the jargon.

1. So how beginner friendly is it?
2. Are there good tutorials?
3. Are there difficulty levels, like less mechanics for beginners? I found the UI a bit overwhelming.
4. How frustrating is it if you don't understand the mechanics at first?
5. How long does it take to learn the rules? How complex are they? Do I need to remember stuff like: oh I can only cast this if the day of the month is a prime and the mother of the target was born under the sign of zock or can I just happily nuke everything with fireballs?
6. I have only time to play on weekends. Is it easy to get back into the game or do I need to remember most of the past story to enjoy it? So is it casual player friendly?

Thanks.