Do you have any other SMS/MMS apps installed? (if so you need to uninstall them and swipe to clear that notification. Send yourself a pic to test it's all OK now). Check in the stock app to ensure MMS > Auto-Retrieve is OFF
Note: on occasions the MMS content is corrupted on your carriers server, so you may need to right swipe this away to ignore it.