If wanting more control over sorting in macOS Mail (or need to fix a mail sorting issue) use column view (and then switch back to preferred view if desired.)
Use column layout in Mail on Mac
When you use column layout to view email messages, the message list appears in columns across the Mail window, and the message preview appears below or to the side of the list.
In the Mail app on your Mac, choose View > Use Column Layout (a checkmark indicates the layout is in use).
Do any of the following:
Change which columns are visible: Control-click a column header, then choose an attribute, such as Muted. The Conversation, Status, and Subject columns are always shown.
Show the message preview on the side or bottom: Choose View > Show Side Preview or View > Show Bottom Preview.
Change how messages are sorted: Control-click a column header, choose Sort By, then choose an attribute, such as From or Size, and a sort order.
Reorder columns: Drag a column left or right to change its location.
Show the messages in a conversation: In the Conversation column, click the arrow .
Sort emails in Mail on Mac
You can sort email messages in the message list—for example, by person or date— so it’s easier to find messages.
In the Mail app on your Mac, choose View > Sort By, then choose an attribute, such as From or Size, and a sort order.
If you’re using column layout, you can also Control-click a column header, choose Sort By, then choose an attribute and a sort order.