Senior Certified Instructor
If I may expand on what @Anna C has said about the goblet squat:How do we progress on goblet squats? I thought the idea is to reduce and eventually get rid of the weights?
There are many ways to squat and multiple, sometimes conflicting goals that can be the training goal focus. It's best to pick a specific goal then address it with a specific plan.
E.g., if moving well is the focus, specifically things like opening the hips, finding one's best squat stance, learning to lengthen the spine, assuring good weight distribution, etc., then a good goal is to reduce the weight while keeping posture and depth. Indeed, this is a good use of the goblet squat for _anyone_, and it could be argued that achieving all these things with a light to moderate weight should be a prerequisite for heavier squatting and perhaps even for heavier other lifts as well.
If you want to move better than simply being able to do a good goblet squat with a light to moderate weight, then you try to go lighter because the weight in the goblet position, while it can facilitate finding a good squatting movement pattern, can also compensate for not having that pattern. We must start where we are - the beauty of the goblet squat is that the counterbalance of the kettlebell lets people who could never squat well get a feeling for what the movement should be like. And for those who squat OK, it still provides a measure of freedom from worry about falling over backwards while looking for one's best form - maximum depth, comfort, and stability in the bottom position.
But one can also load the goblet squat with a goal of simply being able to squat a heavier weight. That's also a fine goal but, at the end of the day, if you want to squat truly heavy, the goblet squat isn't going to get you there because the weight becomes awkward to hold long before it gets heavy as a squat weight. At that point, racked kettlebells become a better choice - twice as many bells, better supported, means you can use more weight.
But even racked kettlebells become awkward at some point, and then a barbell front squat or other barbell squat becomes the way to load the squat truly heavy.
If I were to put these things into an order, it might be:
Bodyweight-only squat using hands on a fixed object for support (e.g., upright of a power rack).
Goblet squat with a light weight (~24 kg for men).
Goblet squat with both less and more weight, noting the differences and working on both.
Double Kettlebell front squat with yet more weight (men under 100 kg, work up to near bodyweight).
Barbell front squat with yet more weight.
Barbell back squat with yet more weight.