Brian Wilson was married to wife Melinda Ledbetter for 28 years after falling in love in a story that eventually made the big screen