NW would try to accomodate you on the next available. Delays happen all the time. Guess I would do a TTU message explaining what happened from you viewpoint.
Did you notify them of your intention to drop the last leg when you headed for the rental cars? AND re-confirm your return flights? If not, make the call now or you may have a nasty surprise when you try to do the return!