Ain't that the truth.
Just hit over 120k DE last night.
*sigh*
Suppose I'll upgrade my King...choose King because I don't want to lose my Queen. Queen is a million times better for farming.
The only option for you, apart from gemming is to skip 1-2 wars while the upgrade completes. Temporarily join some other clan.
it's 227 days
Everybody agrees on the topic of heroes and use in clan wars. If everybody agrees and there is no downside besides profit loss then i expect to see it in the next update
Businesses make money. Having things unavailable for a certain time period is part if that model. If you want your hero now, you gotta gem it. Otherwise, be patient as its a free game. You pay for your impatience.
If you read the countless threads about this topic then you would know not everyone agrees. Some say that they would rather SuperCell make money this way then forcing gems in another way. There are a few other arguments (such as not being able to use the spell factory or anything else in the base so why the hero?), but you can look them up.
In any case I doubt if the main reason this happens is money SuperCell would put it in the next update. They are ultimately a business.
Whether you can or cannot use heros in wars, its fair as long as the same applies to everyone. You can't use your hero to get one more star but likewise there's someone in the enemy clan who got one less star due to that.