But that scene made it feel somewhat non-romantic to me like she was trying to help Cloud more than anything and worked towards that until the end.

I haven't read the novella but even Aerith didn't respond to Zack, I don't think she didn't have any feelings for him. Besides, in the Advent Children, it looks like they reunited in the Lifestream and all.