I think a great solution to the wobbly rocket problem would be to have a small series of intentionally unstable “found on side of road” parts that is hilarious for early stages of the game. This ropes in new players for the explosions but still inspires you to improve your rocket design. As you acquire new parts, the rigidity quickly diminishes, and is only present in the edge cases you've mentioned (long cantilevers, etc). This inspires players to move past the parts that are introduced at the start of the game into the larger and more powerful parts. The unstable parts would still be great for small-scale crafts.