Although my answer will nowhere approach the level of mathematical sophistication of the other answers, I decided to post it because I believe it has something to contribute -although the result will be "negative", as they say.
In a light tone, I would say that the OP is "risk-averse", (as most people are, as well as science itself), because the OP requires a sufficient condition for the 2nd-order Taylor series expansion approximation to "be acceptable". But it is not a necessary condition.
Firstly, a necessary but not sufficient pre-requisite for the expected value of the Remainder to be of lower order than the variance of the r.v., as the OP requires, is that the series converges in the first place. Should we just assume convergence? No.
The general expression we examine is
$$ E\Big[g(Y)\Big] = \int_{-\infty}^{\infty}f_Y(y)\Big[\sum_{i=0}^{\infty}g^{(i)}(\mu)\frac{(y-\mu)^i}{i!}\Big]dy \qquad [1]$$
As Loistl (1976) states, referencing Gemignani's "Calculus and Statistics" book (1978, p. 170), a condition for convergence of the infinite sum is (an application of the ratio test for convergence)
$$y-\mu < |y-\mu|<\lim_{i\rightarrow \infty}\left | \left(\frac {g^{(i)}(\mu)}{g^{(i+1)}(\mu)}(i+1)\right)\right| \qquad [2]$$
...where $\mu$ is the mean of the r.v. Although this too is a sufficient condition (the ratio test is inconclusive if the above relation holds with equality), the series will diverge if the inequality holds in the other direction.
Loistl examined three specific functional forms for $g()$, the exponential, the power, and the logarithm (his paper is in the field of Expected Utility and Portfolio Choice, so he tested the standard functional forms used to represent a concave utility function). For these functional forms, he found that only for the exponential functional form no restrictions on $y-\mu$ were imposed. On the contrary, for the power, and for the logarithmic case (where we already have $0 <y$), we find that the validity of inequality $[2]$ is equivalent to
$$y-\mu < \mu \Rightarrow 0 < y < 2\mu$$
This means that if our variable varies outside this range, the Taylor expansion having as expansion center the variable's mean will diverge.
So: for some functional forms, the value of a function at some point of its domain equals its infinite Taylor expansion, no matter how far this point is from the expansion center. For other functional forms (logarithm included), the point of interest should lie somewhat "close" to the chosen center of expansion. In the case where we have a r.v., this translates to a restriction on the theoretical support of the variable (or an examination of its empirically observed range).
Loitl, using numerical examples, showed also that increasing the order of the expansion before truncation could make matters worse for the accuracy of the approximation. We must note that empirically, time-series of observed variables in the financial sector do exhibit variability larger than the one required by the inequality. So Loitl went on to advocate that the Taylor series approximation methodology should be scrapped entirely, regarding Portfolio Choice Theory.
The rebound came 18 years later from Hlawitschka (1994). The valuable insight and result here was, and I quote
...although a series may ultimately
converge, little can be said about any
of its partial series; convergence of a series
does not imply that the terms immediately
decrease in size or that any particular term
is sufficiently small to be ignored. Indeed, it
is possible, as demonstrated here, that a
series may appear to diverge before ultimately
converging in the limit. The quality
of moment approximations to expected utility
that are based upon the first few terms
of a Taylor series, therefore, cannot be determined
by the convergence properties of
the infinite series. This is an empirical issue,
and empirically, two-moment approximations to the utility functions studied here
perform well for the task of portfolio selection. Hlawitschka (1994)
By example, Hlawitschka showed that the 2nd-order approximation was "successful" whether the Taylor series converged or not, but he also verified Lotl's result, that increasing the order of the approximation may make it worse. But there is a qualifier for this success: In Portfolio Choice, Expected Utility is used to rank securities and other financial products. It is an ordinal measure, not cardinal. So what Hlawitschka found is that the 2nd-order approximation preserved the ranking of different securities, compared to the ranking stemming from the exact value of $E(g(Y)$, and not that it always gave quantitative results that where sufficiently close to this exact value (see his table A1 in p. 718).
So where does that leave us? In limbo, I'd say. It appears that both in theory and in empirics, the acceptability of the 2nd-order Taylor approximation depends critically on many different aspects of the specific phenomenon under study and the scientific methodology employed -it depends on the theoretical assumptions, on the functional forms used, on the observed variability of the series...
But let's end this positively: nowadays, computer power substitutes for a lot of things. So we could simulate and test the validity of the 2nd-order approximation, for a wide range of values of the variable cheaply, whether we work on a theoretical, or an empirical problem.