I would have no problem riding in front of the monorail again.
If you consider the number of trips that a monorail makes daily and multiply that by 5 tracks (3 in WDW and 1 in DL-California, 1 in DL-Tokyo) and then by the number of years each track has been open there have been thousands and thousands and thousands of monorail rides. In all that time on all those rides there has been a single fatal accident. It was a terrible accident, but in many ways (from the reports I have read) a freak accident.
I do not live my life in fear of things that have a very low probability of happening, like another freak monorail accident. I can understand that some people may no longer feel comforatable in front and that they feel that it is unsafe. However, it is statistically far more dangerous to drive to the parks or even take the WDW buses to the parks than it is to ride in front on the monorail. If Disney continues to allow us to ride in front we'll be there!