You should have it checked for the proper operation of the transmission range sensor, which will tell the engine processor what gear you are in. Other than that, yes, you are looking at a mechanical failure that will need significant repairs.
RepairPal Certified shops can diagnose and repair your 1994 Ford Probe. They provide transparent pricing with a minimum 12-month or 12,000-mile warranty on repairs and services.