I mean, if you get the dream sequence with Aerith then she literally tells Cloud not to fall in love with her. Can't spell it out more obviously than that. Aerith doesn't love Cloud, she loves the part of him that tries to be like Zack. Similarly Cloud doesn't love Aerith, but he does love the almost maternal way she acts towards him.
This is such a bi-dimensional take on love and people.
I believe Cloud and Aerith both love each other, but Aerith always knew something was probably going to happen to her (not necessarily that she was going to be stabbed in the gut, but as the last ancient her priorities were going to be something else, whether she liked it or not)
Of course, she knows something is up with Cloud but that doesn't mean she doesn't see him for what he is (a fragile messed up man that wants to be better).
Cloud as well, even after he recovers his original persona keeps thinking about Aerith.
And this is without entering the extended universe with the novels, movie and sequel/remake. I took Aerith's message in Remake as to try to avoid causing him more grief but from a perspective of love as well (not motherly love). But aerith's character in Remake is a whole bag of cats that we can't get into yet.
They all love each other very much. For obvious reasons (mortality) Cloud and Tifa end up together and a true relationship forms from that. But it doesn't cancel Cloud x Aerith