An easy way to improve your situation is to sell the BMW and get a more practical and reliable vehicle. Granted, that works more in favor against the rental car.

I also don't think it's a given that you'd need a rental car every single weekend. If you need a car every single weekend then owning one yourself clearly makes the most sense. It's when you only need the car occasionally that it would make more sense.