I don’t get it. Either Y is true or it’s not. If it’s true then adding “it turns out that Y” is not any more or less true than Y (except to the extent that the speaker may never have believed otherwise, but even then the statement is primarily about the truth of Y). If Y is false then “It turns out that Y” is no more misleading. Without “it turns out” you may not be conveying a change of belief or rigorous research, but you are still claiming you know something to be true, when you really don’t.