You are correct in asserting that unpolarized light contains a mixture of many polarizations. However, each of these polarizations can be expressed as a combination of horizontally and vertically polarized light. Diagonally polarized light can thus be seen as containing both horizontally as well as vertically polarized light.
When a horizontal beam of diagonanally polarized light strikes a vertical window under the brewster angle, the horizontally polarized component will be perfectly transmitted. The vertically polarized component of the diagonal beam will be partially reflected and partially transmitted. The reflected light is thus fully vertically polarized, while the transmitted light still contains both polarizations. However, since part of the vertically polarized light has been reflected, the polarization of the transmitted light will be somewhere between diagonal and horizontal.
For unpolarized light this means that for every polarization only the vertically polarized components will be partially reflected. The transmitted beam will thus still be a mixture of polarizations, but on average it will be somewhat horizontally polarized.
Note that here I used horizontal and vertical polarization as the two components of the light, but one might just as well have chosen to express the light as a combination of two components polarized along the diagonals. In reflection experiments, one typically chooses to use a component in the same plane as the direction of the beam and the surface normal (p-polarized) and a component perpendicular to this (s-polarized).
Physically, the reason for this effect is that the reflection of light from a glass plane can be seen as the absorption and re-emission of light. The dipoles in the glass start to oscillate when they absorb a photon. They can then again emit this photon, which can be seen as the reflected light. Note that as the electric field is always perpendicular to the propagation direction of the light, the dipoles also oscillate perpendicularly to this propagation direction. Since the electric field of the emitted light also has to be perpendicular to the propagation direction of the emitted light, the dipoles can only emit photons in a direction perpendicular to the direction of oscillation.
For the Brewster angle, the direction of propagation inside the glass (thus after refraction) makes a 90 degree angle with the direction of the reflected light. This means that when the dipoles in the glass are excited by p-polarized light, they cannot emit in the direction of reflection, since the oscillation direction and the direction of reflection are aligned. At the Brewster angle, there is thus no reflection possible of p-polarized light.
Note that in the picture sketched here, the reflection occurs everywhere in the glass, not just at the interface. The resulting reflectivity and transmitivity are however identical to models which model the reflection to happen only at the interface. For a detailed explanation on how these models are equivalent Feynmans book "QED" is an excellent introduction. It explains the principles of QED with hardly any math.