To me, this is kind of like asking, "Are pencil skirts 'in'?" They will always cycle in and out of fashion fad as the hot new thing of the season, but they will always remain classic. Point toed shoes are as elegant and feminine as almond or round toed shoes, imo, and not inherently more sexy or trashy than any other toebox. In fact, it could be argued that point toed shoes are as Upper East Side as one can get in the shoe world, as Mr. Blahnik, a favorite of the ladies-who-lunch crowd, has sworn that he will never stop making his classic, point toed, 70mm and 85mm pumps and slingbacks.
OP, wear them proudly!