The cracked tile would suggest,plywood to thin, joist to small or overspanned. the waterproof membrane should run up the walls some inches. Like Old Dog I can not see where the water is draining . What is the slope of the deck?
I too think it might be better to look at a light weight roof.