In our case it's the weekend trips with the kids. Cars big enough to carry all kids are expensive and relatively rare. Renting over the weekend is expensive. And working on Fridays and Mondays makes it difficult to go out to a rental station and get one of those cars or return it in time.
So in the end, it's certainly doable but more expensive than owning and creates more stress/hassle.
E.g. pets. Most rental companies don't allow pets in their cars.
And there might also be situations where the next rental company is far away and you'd spend a lot of time going there. Depending on how often you need a car, having your own in front of your house might be the better choice.
Same for long holidays where the rent for a car can easily be a big chunk of your holiday budget even if you only need it for a few days during your trip.
I get trains, but what are some of these car-requiring scenarios where a rental won't cut it?