Nothing funny with it. The name "Moldavian/Moldovan SSR" was built on the same pattern as every name of the constituent republics of the USSR: [adjective derived from the name of the nation] + SSR. This was changed to the pattern "Republic + [name of the country], so a substantive. Nothing particularly unusual in the pos-Soviet world, and certainly nothing subversive. The substantive "Moldova" never ceased to be used in the Romanian/Moldavian language throughout the Soviet period, it's just that the official, formal name of the Republic used the adjective derived from this word(which was, as I said, a standard practice in the Soviet Union).
Standard practice being that the Russian name was used not the Romanian name. This was part and parcel of an attempt to russify the population. If it had ever been known as Moldovan SSR then it would hardly have required an act of parliament to change this name back to Moldova. It never was called that other than in "Moldovan" but since nobody really cared what the Moldovan name was, the official name was the Russian one.