It does sound like conditions were bad. Controller asks pilot if he can maintain visual contact with the runway, which suggests the controller had concerns about his ability to do so. Conditions were probably bad.
Other pilots are asking for deviations around weather near KPOU.
did he ask for the straight in because visibility and cgs were bad?
Plane struck the house inverted, so whatever might have happened mechanically, the pilot departed controlled flight and rolled the plane upside down.
My speculation: ceiling and vis were bad. He was nervous about getting down visually, which is why he asked for the straight in even though the wind clearly favored 20. He lost sight of the runway during the downwind while he was low and slow. Cranked the plane around too hard, or got disoriented and stalled at a low altitude, rolled it over and stuck it in the house.