I would love any feedback on my second draft circuit
Do I need a diode between the load and the MOSFET?
Q1 and Q2 has no resistance to Gnd from 12v so wil destroy something.
Much better ! The other suggestion I would make is a 12V Red Lamp/HORN in parallel with the solenoid so that when the FIRE button is pressed the RED lamp lights/HORN SOUNDS while the FIRE button is depressed. Admittedly, that would only be frosting on the cake. I think you're "Good to Go" now. I'm not sure if it matters to you but technically the Truth Table is incomplete because it does not include the FIRE button,which admittedly is effectively a "SOLENOID ENERGIZED" button. (FIRE button input,Solenoid Energized Output)
Why don't take some time to learn electronics.