I would like to try my hand at cooking and I did try once or twice but didn't get encouragement from family members probably because my cooking was bad. I do like to watch live cooking shows but then that is it. No live cooking for me.
What has really helped me is to just make the same thing a bunch of times, and focus on one thing at a time. I am not a great cook, but what I can make I can now make pretty well. I am confident from experience and that means I know when it goes well, wrong, and when I can improvise and what I can do to take a dish to the next level.
Basic cooking skills like prepping, understanding timing, and even things like holding a knife and cleaning up while you cook. It gives you less stress and you have more time to clean up and more time to prepare and cook and do it well.
The more you get familiar with certain things you can do really well, the easier it is to scale it up to a family dish, or to add other things on the side and get away with it not being perfect because the main dish is just really good.
Don't let family discourage you, but invite them to help you while you cook - that way they also feel they can't complain about it because they're the ones who partially made it.