With how many overpowered SSR's Water have I don't think many need an Awakening compared to other attributes, maybe Aphrodite, Shiva and Poseidon?
For those three water has Nike Unleashed, Cthulhu, Ryu-Oh, Snow Raphael, and they all can be treated as "Water Cores"

If I were to be a fair Dev in DMM I'd fix Thunder, that yes is better with Mammon but nothing to be proud of...