Acutally, "car subs" will work fine in a house, as long as they are enclosed properly in both cases. Of course, in a car, the SPL levels will be much higher, since the pressure is kept within the confines of a car, versus your living room.
House speakers tend to be lighter, too, so they run a little more efficiently. There is not as much need for heavier poly cones and other weather-resistant designs in the house. That's another reason house speakers tend to sound better in houses - better efficiency with lighter cones.
Lastly, home amps (aka Sony crap) don't drive a lot of current, so subs simply don't perform well. Get a nice current drive amp and you'll be fine

I love my Onkyo for that reason alone.