Each lens profile is originally generated either from Raw or from non-Raw test shots. Accordingly, the profile is marked as suitable for correcting either Raw, or non-Raw pictures taken with that same lens on that same camera format. So it will either show up, or not, in the automatic lens profile detection of LR or of ACR depending on the type of file involved.
Generally speaking, only Raw specific profiles are made available for many lenses... because that is the principal demand. The usual case will be that lens correction has previously happened, from the original Raw data, as part of Lightroom's general processing that has gone into any TIFF created; hence, that TIFFs can be normally assumed not to be in need of such.
This separation of two kinds of lens profile is clearly necessary in some cases; for example where aberration correction will have been already applied by the camera, but to its JPG output only; and/or, where LR is doing some (possibly different) automatic lens correction "silently", for Raw - as with its support for some m43 systems.
However where this is not the case - where no prior correction is in question - a Raw-specific lens profile can be "kludged" so as to be perfectly usable with TIFF, JPG etc - which is far better than nothing.
The way to do this is to make a duplicate copy of the profile (.lcp) concerned - changing its filename slightly to suit. Then in a text editor, in this copy, change the line which refers to "CameraRawProfile" from True to False. That's it!
If there is some double correction going on, the option is also there to selectively disable profile-based correction of vignetting, or of geometric distortion, or else to disable CA removal, as appropriate - and to then save that option into a preset or as your LR processing default.
