I don't understand everyone saying how far of a walk it is from the standard rooms at Art of Animation. Yes, the standard rooms are the farthest away from the main building and the bus stop, but AoA is still a comparatively compact resort overall. Caribbean Beach is absolutely huge and sprawling. If you are in a standard room, you are likely going to feel like you are in another county from the shops, arcade, restaurants, etc. Yes, it has multiple bus stops, but other things are quite a trek to get to.
That said, AoA is a value resort so the amenities are not going to be as good as at a moderate. There is no table service restaurant, just quick service. The rooms are slightly smaller. There are no water slides at the pools. Etc. And, yes, the Little Mermaid rooms probably wouldn't appeal, theme-wise, to boys who aren't interested in princesses. All that said, we love AoA and I wouldn't hesitate to recommend someone staying there.