Irrationality of threefolds via Weil's conjectures