I give reason why he should go Andromeda.
1. Water can reach cap without hercules so using hercules isn't effective.
2. Water can get ascension by using one Orihalcon so your andromeda can heal 2032 your nike will heal around 1100. Its very important to do GO with best endurance.
3. If you use andromeda soul weapon Andromeda can heal 2832 with soul weapon skill. Healing is very important in GO for new players.
4. If taking hercules it needs long time to get 25% weapon frame. You need 120 regalia while Andromeda healing don't matter with limit break. So you only need 40 regalia to have the effectiveness of the weapon.
5. You have snow raphael no need to get more debuffer b frame you better of getting Joan but joan can't heal newbies don't have appropriate damage to use joan. So getting andromeda then getting joan is the best route.

I can play glass cannon build cuz I play long enough and have enough himes. Honestly glass cannon build need experience and decent damage. Something most new player don't have now. So better go balance build first using Andromeda then go glass cannon build and going hercules when you have proper grid and himes.