I’m your inverse (MTBer that got into road biking).
First, I would recommend a hardtail over full suspension. Hardtails are bulletproof, there’s way less maintenance, you’ll typically get better components for your budget, and at this point in your progression it will do everything a full suspension will and then some. If you and your son end up loving mountain biking and you have a sense of what kind of trails you enjoy, you can “upgrade” to a full squish that’s designed for those trails and keep the hardtail as part of your quiver, loan it to friends, convert it to singlespeed, try bikepacking, the list goes on. If you decide it’s not for you, a hardtail will retain its value much better on the secondhand market.
If your trails are mellow and/or you’re a masochist, You can find some fully rigid bikes, but otherwise look for something around 100-130mm. Any longer than around 140 and the geometry gets weird as it goes through its travel, any shorter is a gravel fork. Most of the component brands will be familiar to you and even the lowest tier drivetrain and brakes from any recognizable company are pretty damn good nowadays. The only component that’ll be really new to you is a dropper post. Get one! Do not be tempted to go rigid! If you’re looking at OEM parts on an existing bike, unless it’s an old hydraulic SRAM dropper, most any dropper on a bike from a reputable company will be fine for now. If you’re upgrading a rigid post, OneUp makes one of the best and they’re one of the most affordable too. Steel or aluminum will save you a ton of money and the weight penalty is less important off road. Your tires will play a huge role in how the bike rides. Ask your LBS and look at what others are riding on your locals to figure out what tread pattern, casing and size would be best for you.
As someone above said, get knee pads. You don’t need anything too armored, just a simple sleeve with a thin pad that you’re comfortable wearing while pedaling. Glasses are a must too, branches come out of nowhere and treaded tires kick up rocks. Use your road glasses if they work or just go to the hardware store and get some cheap clear ones, but protect your eyes.
Last tip, leave the tech at home or keep it out of eyesight. I’m not saying don’t track your ride, especially if that’s how loved ones know where you are, but the draw of mountain biking is being immersed in nature and nothing your bike computer can tell you is urgent or even useful in the moment. If you’re using it for navigation, you’ll have better luck stopping and looking at the map than relying on turn by turn guidance, which has always been pretty poor off road in my experience.
Most important, have fun!