Nothing strange there, using left joins means that you get ALL selected rows from the first table.
I guess what you actually want is a pivot. But as you don't state what version of sql-server you have, I can't be sure it's supported.
But don't worry, it's easy enough to do with a
CASE WHEN
Try this or a variation of it:
SELECT TicketType
,Sum(CASE TixStatus WHEN 'OnHand' THEN 1 ELSE 0 END) AS OnHand
,Sum(CASE TixStatus WHEN 'Pending' THEN 1 ELSE 0 END) AS Pending
,Sum(CASE TixStatus WHEN 'Sold' THEN 1 ELSE 0 END) AS Sold
FROM TicketStatus
WHERE ConcertTitle = 'Blink182 (Get in the Phil)'
GROUP BY TicketType