I sympathise OP, as I used to live on an estate of Victorian terraced houses. It was in easy walking distance of the town centre and the railway station. I didn’t even have a car, even though I worked one day per week in another town.
Yet, the street was clogged up with cars on both sides. My friend with arthritis couldn’t park in our street when he came to visit. I had great trouble getting a new sofa delivered, as the delivery driver couldn’t park nearby. And I knew DD would never be able to walk to school by herself as the streets were too dangerous - there was nowhere with good visibility to cross the road.
The Council held a meeting to discuss a Residents’ Parking Scheme. Some people were strongly opposed. One irate man said that two permits per household wasn’t enough, as he had adult children. My response would have been that he could have as many cars as he liked. But he couldn’t park them all outside his house, could he? Because there wasn’t room.
Personally, I think the people with excess cars should have parked them in a car park. Or, they should have realised that if you want to live in easy walking distance of the town centre, the trade-off is fewer parking spaces.
Anyway, the Council will soon be imposing a Residents’ Parking Scheme and I’m glad.