Hi Cheryl and welcome to the site
I think it’s probably fair to say that quite a lot of people get told MS out of the blue Tbh, expecting it doesn’t make things all that easier - either way it’s a hard thing to hear and very difficult to get one’s head around I can tell you that it gets very much easier as time goes on, but for now the best thing to do is to take it one day at a time, don’t bottle things up and be kind to yourself.
LPs are normally no trouble at all. The most painful bit should be the local anaesthetic so you’ll know what to expect if you’ve had one of them before (“sharp scratch” e.g.). Some people get a bad headache afterwards. This can be helped by lying down afterwards for several hours, drinking lots of fluid (preferably with caffeine in it, e.g. coke, if you can) and taking painkillers. Ideally, you could ask for the hospital to use an “atraumatic needle” to do the LP - this significantly reduces the possibility of the headache.
As far as googling MS goes, please don’t! There are an awful lot of bad websites and an awful lot of bad advice out there! Best to stick to reading the MS Society and MS Trust booklets on MS. These are free to download and to order in hard copy. One thing you really need to keep firmly in mind when you’re reading though: MS is massively variable. That means that you will NOT get everything that the booklets mention: they have to cover every possibility; no one gets everything! And even the things that people do get vary massively in severity so may only affect them very mildly.
The thought of MS is a very scary thing. For the vast majority of us though, the reality is nowhere near as bad. People with MS can still do all the important things in life (and most of the unimportant ones too :-)) and can honestly have long, happy and fulfilling lives. We’d none of us ask for MS, and life may work out different with MS than we’d planned, but life can still be good. It is NOT the end of the world by any means. Promise