What if the arresting officers passed away and your DUI case goes to trial Will it be dismissed?

It's possible, but unlikely. That's one of the reasons why police have to write complete reports. If the reporting party is deceased when the matter goes to trial, the reports will suffice as the best evidence.

You are more likely to have the case dismissed if the officer is alive and well and simply fails to show up in court despite being subpoenaed.