It sounds like you were trying to be too nice and were trying to appease both sides; that’s a losing proposition. You are working with adults, and adults should be able to handle bad news (if handled properly), and a good manager should be able to bring the bad news but at the same time give enough context so that everyone understands.