Ah, e6/g6 being weak sounds like the key idea I've been missing. Sounds like it's closely related to back rank tactics in order for f7/f2 attacks to work.
Improving at "Attacking f7/f2"

How does a castled king give up castling rights? Are you saying f7/f2 attacks work better before the king castles?

How does a castled king give up castling rights? Are you saying f7/f2 attacks work better before the king castles?
its not that it works better or not...either it works or it doesnt...however, attacking f7/f2 before and after castling are seperate forms of patterns...for example, after castling results in the type of rook pin/back rank mate that you were asking about, while before can lead to open kings and weak e6/g6 etc

A nice idea sometimes missed is where you have the bishop pointing at f7 when the king is castled kingside and you land a piece on g6 (usually a knight) because fxg6 is impossible due to the pin.

@Strangemover How would that work?
obtuse much? come on man, he isnt talking about specifics...just sometimes its a thing...like in the postion, what if the black queen was on e7. You would have yourself a successful fork, and the opponent may not be so aware of it due to the pin of the f pawn.
My tactics have skyrocketed the longer I've used tactics trainer, but I can't help but notice the theme I score the most poorly in:
I notice from my games I fail to understand how a castled king can be pursued by f7/f2-related plans. I believe I'm missing some bread and butter sort of plans related to f7/f2, probably due to my style of game play being "win with tactics". My best guess is that f7/f2 requires more of a positional-style attack. What are some bread-and-butter f7/f2 ideas?