nowadays more people are using mirrorless and entry level DSLR, does it mean they must use manual mode or p mode?
Why not? You have a camera that do all that so why not learn how to use those modes as well? In fact, to get what you want, it's best that you go to those modes.
they are still have people use semi pro or pro DSLR model in auto mode too.
Please don't use others as an excuse.
camera maker are now making the auto mode more intelligent to able to detect what scene mode to use.
But not as intelligent as the tool behind the camera.
i am willing to learn but it mean this camera only i know how to use. my family member know nuts and want simple PNS.
As you have mentioned, most cameras have auto and manual modes. These modes can be accessed with the simple twist of a dial.