Automatic alignment implies the table extends from margin to margin. Whenever you change a column width, width of columns after this one (depends on writing direction; columns at right for left-to-right) are recomputed so that the table remains margin-to-margin.
With other alignments, you define the table width. It can be narrower than the area between the margins or it can overflow in the margins. You decide according to your needs.
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.