You may have misread what I written and thought I was suggesting comparing effective tax rates both now and in retirement, which would also be incorrect; I'm not. The correct comparison, again, with the caveats listed above, is marginal tax rate now vs effective tax rate in retirement.
No.
The effective rate in retirement is a completely useless number for this purpose. People keep suggesting that this number is relevant to this decision, and they are wrong.
We're looking at whether it makes the most sense to contribute to Roth or traditional this year. Suppose that based on your prior and planned contributions
outside of this year, you expect to have $325k in pre-tax retirement accounts when you retire. No pensions or other sources of regular (non-capital-gains/qualified-dividends) taxable income, just the IRA/401(k)/403(b)/whatever. Per the 4% rule you might then plan to withdraw $13k/year from your pre-tax retirement account. That's $450 above the standard deduction for a single person. You'd pay 10% tax on this $450, making your effective tax rate be $45/$13,000, or 0.35%.
Now this year you have some more money to contribute. Let's say it's $12.5k (pre-tax) you have to save this year, and you expect it to double by the time you retire. If you put it in your pre-tax retirement account that will bring your balance up to $350k, and increase your annual withdrawals by $1,000. Now instead of expecting to be $450 over the standard deduction every year, you expect to be $1,450 over the standard deduction. You'll pay 10% tax on this amount, making your effective tax rate be $145/$14,000, or 1.04%.
Are these effective tax rates actually useful for this decision? No! How am I supposed to use this 0.35% (or 1.04%) rate to decide anything? It's not as though I'm actually paying 1.04% on this year's withdrawals. I'm already filling up that standard deduction just from money I've contributed (or plan to contribute) in other years.
What matters is the marginal rate. Before you made this year's contribution you expected to have $13,000 regular income during retirement, and afterward you expected to have $14,000. Before this year's contribution you expected to pay $45 tax, and afterward you expected to pay $145. That's a 10% rate you're paying on the $1,000 of annual withdrawals attributable to this year's contribution. Always compare the marginal rates.