MTW is like the old saying "Keep your friends close and your enemies closer."

Gaining allies seems to only really help at the early stages of the game. I have never had an allied faction break an alliance in the first 50 years or so. After that most players will have a nice empire and the other factions start to get worried. They don't call the game Total War for nothing.