You are correct. The Effect Test is based on the type III sum of squares associated with adding a term to the model. It is the F test. You have one F test for each term. This test is useful for model reduction and inference about factor effects.
On the other hand, the Parameter Estimates reports the t test because it compares the estimate to the value of the null hypothesis, which is that the parameter is zero. (You can test against other null hypotheses with a t test but JMP does not provide such a test. There is a script for this purpose.) You have one t test for each estimate.
If you want to see the results for the last level, click the red triangle at the top next to Fit Least Squares and select Estimates > Expanded Estimates. (JMP does not report the last level by default because the estimate of the last parameter must be equal to the negative of the sum of the other parameter estimates. You can enable Expanded Estimates in the platform preferences if you like.)
The interpretation of these tests is limited to an independent test versus 0. Your example concludes that the estimates for level 1 and level 2 are different from zero. That is all that you can say. These tests do not compare these levels to the last level. You could use an additional contrast for this purpose.
You also have to be concerned about the multiple comparisons issue of inflated type I error rate with all these tests.