I failed, even with my own kid! When he was very young, he would hang out in the shop and I'd encourage him to help me. He developed some basic skills and was able to build the last couple of pinewood derby cars, and he did most of the work on his Eagle Scout project. But the love of it just never "took" with him. He's in graduate school now, and we recently had a conversation about why he never took an interest in the things that interested me. He said he never felt "clever" about the woodworking and such, so he went where he could excel. I guess it worked out for him, he turned down an opportunity to go to med school because he liked chemistry better.
“We should be careful to get out of an experience only the wisdom that is in it and stop there lest we be like the cat that sits down on a hot stove lid. She will never sit down on a hot stove lid again and that is well but also she will never sit down on a cold one anymore.” - Mark Twain