All love to SE, they made a lovely game. But to expect them to consider all ramifications of a decision before going through with it is not realistic. The housing system has been one reactive change after another.
Housing came out as FC only originally. Players demanded personals and SE said ok. SE promised that personals would be in their own separate wards so that FC and personal housing would not compete and interfere with one another. This proved impossible and was never done.
Housing was originally priced with FCs and omnicrafters in mind, 40-600 million gil at the placard! Players begged for a price cut. Yoshi P said that if prices were lower, then the rich players would buy collections. We said that sounded worth it to us if we got our savings. So house pricing went down by 90% and now everyone could afford one, and some people could afford dozens.
Housing was originally allowed to alt characters. You could have 8 personals per server if you wanted. Not everyone chooses to play alts, but for those that did, this was completely and totally allowed. SE in 2018 realized that if housing was going to be a prestige item, players should not be allowed to build such a large collection. They adjusted the size of future collections, and wisely chose to leave existing collections intact rather than upset valued customers. That said, some people continue to believe this decision was made in error. Some of these detractors respond with forum feedback opposing the decision, some just launch harassment campaigns against their fellow players in game or on social media over it.
So you could say there have been a few mistakes along the way. I'd say that makes it a safe bet there are a few more in our future.