Does lost mode goes into effect once iPhone is turned on
If the phone ever gets an internet connection again it will go into effect, yes.

However if your phone was stolen, you risk that the thief will wipe it and sell it off - probably as parts - and your lost mode setting will be for nothing.

As you have no pass code on the phone, they will be able to see all your pictures and data, yes.