Yes, the 3M Super Trim Adhesive is what you need. Don't bother trying to reattach some foam to the carpet-like layer, just order a new pad if you can. They don't cost much, at least here. Leave the hood on and put it in the service position, but tape and paper around and under it so you don't get glue where you don't want it. Use a plastic scraper of some sort (I used an ice scraper, butyou probably don't have those there...lol!) to remove as much of the old ahesive as possible. Then clean well with something like Simple Green. I sprayed three coats of adhesive (left to right, up and down, and then a diagonal) on the pad and on the hood and waited according to directions. Have a helper to get the pad up to position, because you need to have hands on both sides of the car and you only get one chance to get it lined up properly. I used a paint roller to press it on and a small wood roller (that comes with sound deadener) to press the edges and corners down. Once it's on, just leave it there with the hood in the service position overnight to fully dry. With the new pad I had a hard time closing the hood since the new pad needed to be compressed where the engine compartment dividers seal to the hood. After a few days it got easier.
One extra note. The adhesive is expensive, but I recommend getting two cans. I did it with one, but it was REALLY close. Would be better to have to open a second can for a small amount than come up short, IMO.