I have just read my advice over and I sound awful, I'm so sorry, it's just that I would be gutted to spend all the money, live through all the chaos then sit in your lovely new extension only to find you have to rip up the floors and replace everything because something like a tiny leak inside the wall or a heavy rainstorm got as far as the wood (from above or below) and meant you had to pay thousands and live with the chaos again. The floorboards may be sealed but joists go into walls where the robot can't spray.
It's kind of a disaster wherever you put it. Ventilation under your house is really important as it prevents damp and means any water can evaporate (even at really cold temperatures).
Most people counteract the cold by putting carpet and underlay down to stop the draughts, and if you are putting something on top of the boards you will be making it much better anyway (without the spray foam). The foam traps any moisture next to or into the wood and they will rot. So you will have rotted joists as well as floorboards.
There are actually some really clever underfloor insulation solutions that can be DIY if you are handy, like making a chicken wire cage with at least an inch from each joist and filling it with something like Thermafleece or hemp insulation (only suggesting them because they also allow any damp to evaporate and are natural as opposed to the spray foam which is an environmental horror story for the future).
I would think that perhaps the mortgage company wouldn't explicitly point it out, as I have never heard of anyone doing it, but once they know people do, it will get more explicit. It causes the same problem, rotting wood which you won't be able to see because there is foam everywhere. It's just that instead of a new roof, you would need new joists and floorboards throughout, new flooring and the walls fixed (because water does not simply go away it will find a way round and if it can't evaporate or drain out it will go up the walls and the cold is MUCH colder in a damp house. Also if you live in a house pre 1910, you absolutely should not put in a damp proof course - often mortgage providers say one is needed but if you explain you are in an older house they should waive the condition. DPCs just trap damp below the course, once you plaster it takes a while to leach through so you think it must be something new going wrong.
I think your best bet would be to have the foam removed now, unblock the air vents (inside and out) to let air through before you put your lovely new extension on. That way you won't suddenly notice that your floor is unexpectedly springy because there is nothing holding it up.