Homozygous and heterozygous have nothing to do with whether or not a gene is expressed.
Homozygous = the two genes in a gene pair are the same. Examples: two normal genes, two identical mutant genes
Heterozygous = the two genes in a gene pair are not the same. Examples: a normal gene and a mutant gene, two non-identical mutant genes
Most heterozygous gene pairs consist of a normal gene and a recessive mutant gene. In this case, the snake looks normal. But some heterozygous gene pairs consist of a normal gene and a dominant mutant gene or two non-identical mutant genes. In these cases, the mutant gene is expressed, and the snake does not look normal.
In the case of a butter het motley, the snake has a pair of amelanistic mutant genes, a pair of caramel mutant genes and a normal gene paired with a motley mutant gene. The amelanistic mutant genes prevent the formation of black pigment, and the caramel mutant genes change the orange-red pigment to more of a yellow color. The combination is a more-or-less butter color; hence the name.
As the motley mutant gene is recessive to the normal gene, a het motley does not show the motley pattern. However, if a het motley is mated to a motley or a het motley, some of the babies would have two motley mutant genes and show the motley pattern.
Hope that helps.