You certainly are not making a fool of yourself. Always remember, there are no dumb questions.
You may feel like you have failed with this project so far, but what you don’t realize is that you have amassed a lot of experience AND an enormous amount of physical data that can be put to good use. As long as you haven’t thrown away the castings that you have made so far, together we can calculate what is required regarding the glass beads, to make your lure work for the next attempt.
The only tool that you require to fix all your problems is a gram scale. If you have a gram scale, then we can either do this by PM or do it here on this thread, it is up to you.
It may well be that you need to go for a lighter resin, but regardless, the engineering techniques that I can talk you through are the same. I promise nothing more difficult than add, subtract, multiply and divide, and writing information down for future use.
Dave