So my guess is that we'll get Spiderman in big crossover MCU movies, but it will be just Spiderman in those movies. We won't get Peter Parker anymore in proper MCU movies.
They will keep the Spiderman franchise going to appease Sony and it will take place in the MCU, but it will be mostly self-contained save for some minor cameos and references to big happenings in the greater universe. Based on the information we have now, Morbius already takes place in the MCU and the extra credit scene gives them a way of having Venom in the MCU. My guess is they'll ditch the Venom from the other movies, and move forward with the quasi-MCU venom.