For this scene in particular, I think it is rather noteworthy that while Cloud is doing it for Tifa, it's Aerith who's forcing him to go through the plan - which he didn't agree with at first - and Aerith is having the time of her life there lolol. I do think it constitutes as a shippy moment for Cloud and Aerith, but I don't think he's dancing for her. He's dancing because he's not having a say in it, so I'd say he's doing it because well, he's being pushed around into doing it lol. And Aerith is a reminder that he doesn't have any other plan to enter Corneo's mansion.
This reminds me that while it's Aerith who tells him to go save Tifa and forces him to, I especially enjoyed that despite his clear desire of not wanting to leave Tifa alone, he decided to trust her until Aerith pushed him into helping her. This is the kind of things I look forward to in a ship, so I was indeed very happy to see it.
Last, let's remember that the devs purposefully put
as many moments for Aerith than for Tifa, and that I don't think you can argue that some matter more than others. Both girls have the same weight in the LTD, they did that as so everyone will be pleased (and if Zack is indeed still alive and we get glimpses of his AU timeline, we may even get some Zerith scenes thrown in in the next part(s)). Let's not forget that both cloti and clerith appeal to different people, so what is going to please someone is going to completely uninterest another and vice-versa. This is the mechanics of the game. Also they clearly made the girls friends this time around, so I feel it's their way of saying "enjoy this and stop fighting? Look the girls are friends, be friends too!"