Big-spending Zenit, backed by Russian energy giant Gazprom, had been heavy favourites to secure their third league crown and the second in the last three years, needing only a draw at their home fortress, the Petrovsky stadium in St Petersburg.
But the visitors failed to read the script as they went two up after 34 minutes, Brazilian forward Vagner Love scoring the first with a long-range strike into the top corner before creating the second for Chile winger Mark Gonzalez.
CSKA's Ivory Coast striker Seydou Doumbia added a third midway through the second half before Zenit's Italian midfielder Alessandro Rosina scored a consolation goal in added time.
Wednesday's match had been postponed from August to ease a congested fixture schedule for Zenit, who were involved in the Champions League qualifiers.
"The whole team is very disappointed because we wanted our fans to really enjoy this occasion," Spalletti told reporters.
"But CSKA are a very strong team and they took full advantage of our weaknesses. But we must quickly forget today's defeat and move on. We'll soon get another chance to take the title."
